unlimited category sub category display

[raj_2006]

Hi All,

I want to display unlimited category sub category list using a single query...The same I was doing using 2 queries before....

categories table

1.categories_id(primary and autoincrement)
2.parent_id

data:

1,0
2,1
3,1
4,2
5,2
6,3
7,4

....so on


Categories_description

1.categories_id(primary)
2.name

Now using a single query I want to display the entire category-sub category tree.

Please suggest me.Thanks in advance for your co-operation.

Raj