Do menus have children in MySQL?

Question

MySQL

The menu table contains the fields: name, url, parent (name, where to go and the parent menu item) ...
How to determine that the item contains child elements?

Answer 1

You can make JOIN type
and check that child.name IS NOT NULL
For example