How to make a dynamic menu part in a cms with infinite submenus in php and mysql? -

i have question topic. purpose designing other menus in cms joomla. thought tables in database? illustration there should possible way create infinite submenu. how many tables should have have? give thanks much :)

one table should enough. give every row parentid column , reference primary id of same table. there should root node no pid set.

php mysql codeigniter content-management-system