query needed!!!

[alanzhao]

Hi,

can somebody come up with a query or recursive function can do that?

database structures:

category_id, parent_id, name

output to a select field:

Toy
Toy > Baby
Toy > Baby > 1 Month
Toy > Baby > 2 Month
Clothing
Clothing > Baby
Clothing > Teenage

Thanks!