Groups(Base):
  id = Column(Integer, primary_key=True)
  code = Column(Integer, index=True)
  parent_code = Column(Integer, index=True)

children = relationship(Groups,
primaryjoin='Groups.code=Groups.parent_code', uselist=True)