Select two values from same table in one record

[Jazztronik]

I've got this structure:

menu
------------
option_id
name


options_order
-------------
option_id
parent_id
order

"parent_id" specifies which submenu a menu item belongs to (which parent menu item it has). The value for top level menu items is 0.
"order" specifies order within same submenu.

I need to get a list with all the menu items, plus the name of its parent menu item ("top level" if parent_id = 0).

I could have used just one table, but now it's too late. I'd rather keep it this way right now.

How could I get what I want in a query?

[Jazztronik]

Got it!

This is what I did, just in case it helps someone else:

SELECT m1.name, m2.name as parent
FROM menu m1
INNER JOIN options_order o
ON m1.option_id = o.option_id
LEFT JOIN menu m2
ON m2.option_id = o.parent_id