join sulla stessa tabella

[Gioba66]

SELECT menu.id, menu.menu, menu.padre, menu.link, menu_1.menu as menu1
FROM menu
INNER JOIN menu AS menu_1
ON menu.padre = menu_1.id
WHERE menu.id=27