linking parent and child with same table

SELECT a.menu_name, b.menu_name
FROM menu AS a, menu b
WHERE a.parent_id = b.menu_id

Powered by ScribeFire.