first of all I am sory for my english.
My category structure is shown below. My purpose is to get category structure with single query. I sort my table by path and I get category tree.
sort_order : Indicates sort order between categories with same level
When I run query
SELECT * FROM category order by path;
But result must be as shown below because sort_order of Electronic is 1 and this is less than sort_order value of Computer category 2
- ELectronic - - TV - - - LCD - - - - LED LCD - Computer - - Laptop
Query : SELECT * FROM category order by level, path;