MySQL闭包表分层数据库-如何以正确的顺序提取信息

I have a MySQL database holding hierarchical data using the Closure Table method. A simple sample database create script follows the question. My issue at the moment is how do I pull data out of the database in the correct order? I'm currently using the following select statement.I have a MySQL database holding hierarchical da