[MYSQL] A recursive query?

[eluser]Clooner[/eluser]
[quote author="pistolPete" date="1236978934"]Could you give an example of
- what you mean by "mixed up" and
- what kind of data you are trying to categorize ?[/quote]

Al though I haven't tried it, with MPTT it seems you can't have the same category return at a different place in the tree.

Code:

- Teams
   Yellow
   Blue
   Cyan
   Magenta
   Green
   Red
   Violet
   Orange
- Colors
   - RYB
      Red
      Yellow
      Blue
   - RGB
      Red
      Green
      Blue
   - CMY
      Magenta
      Yellow
      Cyan
   - GVO
      Green
      Violet
      Orange