Use nested set trees
If Scott hasn't already chimed in with some links before I get to work, where I've got them bookmarked, I'll put them here.
===
Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]