The basic concept is that you keep a refference to the parrent, for example:
class Category(SQLObject):
name = StringCol(length=200)
description = StringCol()
childs = MultipleJoin("Category",joinColumn='parrent_id')
parrent = ForeignKey("Category")
