What query is needed in the MySQL database to select all children together with their parents with the Nested Sets structure?

Question

MySQL

Hello, I will have the following structure:
Regions of the country: 24 pcs. (parents);
Districts, cities of regional and district significance will come from each region, and settlements (villages, urban-type settlements) will come from them.
I want to make a selection from the database and sort in such a way that there would be an output like c. Raevka, Sinelnikovsky district, Dnepropetrovsk region.

Answer 1

don't know what you use in laravel for nested sets but here is getting children with all parents sqlfiddle.com/#!9/4997d54/1

Answer 2

For such a structure, separate tables for each entity are more suitable: region, district, settlement.