Another thing to look at if you want to eliminate the recursive retrieval of rows are Nested Sets by Joe Celko. It makes insertion a bit slower but retrieval is much faster than repeated queries for every level of the tree.