Get a Website Built - 18/08/2017 20:20 EDT

Retrieve a complete list of all Categories, Sub Categories, Sub Sub Categories, etc. in only one SQL query only simple code by php and mysqli I need dropdown list like this main cat1 -sub cat1 -sub cat2 --sub cat 1 --sub cat 2 --sub cat 3 ---sub cat 1 ---sub cat 2 --sub cat 4 -sub cat3 -sub cat 4 main cat 2 -sub cat1 -sub cat2 --sub cat 1 --sub cat 2 --sub cat 3 ---sub cat 1 ---sub cat 2 --sub cat 4 -sub cat3 -sub cat 4 all data from table in database mysqli by PHP code this all thing