Script for Parent Child node MySQL Table with search

I need a php script solution to find and show tree structure of parent child nodes table. MySQL Table has following structure: id, Name, Parent 1, Building, 0 2, Room, 1 3, Table, 2 4, Drawer, 3 5, Building2, 0 6, Room, 5 7, Table, 6 8, Drawer, 7 Now if I search for "Table", it should give me a result like this: 1, Building, 0 2, Room, 1 3, Table, 2 5, Building2, 0 6, Room, 5 7, Table, 6 or if a search for Building, it should return 1, Building, 0 5, Building2, 0 I can't use [Recursive] Common Table Expressions, as it is not supported on older SQL version. I am on 5,6, so maybe you can provide me a php (5.x) script solution.