Mi scrive questo


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=35