Feeding a Drill Down Menu with categories, subcategories and subSubcategories from a database

Question

Hi everyone, I have a Drill Down menu and I want to have it gets its elements from a database, I am using php and MySQL and the table (categories) looks like this :

http://yfrog.com/jctablehsj

I can't figure out how I can extract these information in a way I could put it inside the Drill Down Menu !

I found the recursive method (with LEFT JOINs) and the nested method which I barely understood and again I couldn't apply it to the Drill Down Menu.

I found that some people found out a solution with left join and group by but couldn't understand or copy their example !

I would be more than gratefull if you could give me the extact of the query.

Thanks a lot for your hard work,

Hassan