如何使用mysql进行分层数据模式的选择?

I have used hierarchical data modal to store products in database. Products have only main and subcategory, and this is the result when I retrieving the Full Tree of Products.I have used hierarchical data modal to store pr