[eluser]brandingdavid[/eluser]
The database schema is pretty much posted above.
I have one table with all the categories, and have the id of the parent category if needed. The menu index is just for ordering items when displayed.
I need to, without knowing how deep the sub-categories will go, list parent and child categories in an unordered list.