Google for "CELKO nested sets" to find Joe Celko's excellent nested set method for dealing with tree structures in databases. Also check out DBIx::Tree and DBIx::Tree::NestedSets.