Displaying categories and their parents with a recursive SQL query?

Question

PHP

In the Database there is such a construction: How to display a tree, from parents?
PS (output goes by php script via PDO to DOM on button click)

Answer 1

I found a good description of the problem on Habré .
And the actual solution that is needed on PhP

Answer 2

As far as I know - then one request with such a structure - no way. Here, either choose in this form and form a tree in the programming language, or use other ways to store tree structures in the database - nested sets, materialized path, adjusentcy list

Answer 3

If the database supports a recursive sql query, then you can use it, if mysql - you can use a stored procedure - stackoverflow.com/questions/16513418/how-to-do-the...

Answer 4

MySQL 8.0 is expected to support recursive subqueries. In the meantime, it's better to select everything and collect the hierarchy in your code. Moreover, the amount of data is small.