1. GrandParent = Category.alias()
    2. .join(Parent, on=(Category.parent == Parent.id))
    3. .order_by(Category.name))