Witam. Mam taką tabelę przechowującą kategorie i ich zalezności.
Kod
id | parent | neme | level | order
"1",NULL,"root","0","0"
"2","1","Rap / Hip Hop","1","0"
"3","1","Graffiti","1","1"
"4","1","Break Dance","1","2"
"5","2","Polski","2","0"
"6","2","Amerykański","2","1"
"7","3","Graffiti","2","0"
"8","3","Vlepki","2","1"
"9","1","Street","1","3"
"10","9","Skateboarding","2","0"
"11","9","BMX","2","1"
"12","9","streetball","2","2"

Moje pytanie jest następujace. Czy jest mozliwość, aby jednym zapytaniem SELECT tak posortować te rekordy, aby najpier wyświetlało rodzica pierwszego rodzica (parent) wg. order, a potem jego dzieci wg. order, nastepnie kolejnego rodzica i jego dzieci?
Np.
Kod
"1",NULL,"root","0","0"
  "2","1","Rap / Hip Hop","1","0"
    "5","2","Polski","2","0"
    "6","2","Amerykański","2","1"
  "3","1","Graffiti","1","1"
    "7","3","Graffiti","2","0"
    "8","3","Vlepki","2","1"
  "4","1","Break Dance","1","2"
  "9","1","Street","1","3"
    "10","9","Skateboarding","2","0"
    "11","9","BMX","2","1"
    "12","9","streetball","2","2"


Może być bez root'a. Dziekuje za wszelką pomoc.