Excellent article which is a great primer on storing hierarchical data.
However, I ran into a snag using the mptta. Recursion may not be required to query the tree, but it is for building or modifying the tree. I wrote about a different method. I'll post a link as soon as Sitepoint lets me. This method uses the path enumeration model, with a twist. Enjoy.