How to display all submenus of the main menu?

Question

MySQL

How can a query be made to display all submenus of the main menu (all descendants-children-children, etc.)?





submenu refers to the parent ID (i.e. if there is a submenu, then this line is considered a child in relation to the menu specified in the submenu)

PS I tried the options from this answer , but they display only the main descendants, and there are no more descendants.

Answer 1

For your variant (Adjacency List) in one request in any way. You need to recursively execute queries on each individual submenu.
In one request, you can get all the children in the Nested Set or Materialized Path.