Recursive Childs

Hiya, This is something that I'm not able to figure out : I am building something like a Yahoo! directry. I wanted to display a "new" image infront of a category, like Yahoo! does. But I want to show this even if the main category may not have any new link, but a category in that might have, so like that... like hotscripts.com too, so i thought if someone could tell me how to use get all the children : ID | NAME | PARENT 1 X 0 2 Y 1 3 Z 2 4 A 2 5 F 1 6 G 5 if i want to get all children of 1, i want to get 2, 3, 4, 5, 6! how do i get this, thanks!