You could convert that Microsoft approach to MySQL. It has stored procedures. I don't really see the point though. The simplest way to work with tree data in a database is to just walk the tree with recursive calls to the database (SELECT id FROM table WHERE parent_id = ?). There are probably even some CPAN modules to help with this. Don't make it any harder than that unless you're having some kind of performance problems.