How to get the hierarchal data from a table as parent- child relation ship?

cte is there in mysql ?


sample data

id name parentid level
1 test null null
2 bklr null null
3 testchild 1 1
4 testchild1 3 2
5 testchild2 1 1

there is no CTE in mysql

perhaps this article can help... Categories and Subcategories