categoryID 	catParent 	name
1 	         0 	         Watches
2 	         0 	         Earrings
3 	         1 	         Mens
4 	         1 	         Womens
5                3               Rolex



If they are in Rolex cateoryID=5

I want to select

Rolex, Mens and Watches