sqlalchemy multiple joins

models.py

class Person(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String)
    parent_id = db.Column(db.Integer, db.ForeignKey('person.id'), nullable=True)
    other_id = db.Column(db.Integer, db.ForeignKey('person.id'), nullable=True)

    house_id = db.Column(db.Integer, db.ForeignKey('house.id'), nullable=True)
    mouse_id = db.Column(db.Integer, db.ForeignKey('house.id'), nullable=True)

    parent = db.relationship(
        'Person',
        primaryjoin=id==parent_id,
        remote_side=[id],
    )
    children = db.relationship(
        'Person',
        foreign_keys=[parent_id],
    )

    other = db.relationship(
        'Person',
        primaryjoin=id==other_id,
        remote_side=[id],
    )
    others = db.relationship(
        'Person',
        foreign_keys=[other_id],
    )

    house = db.relationship(
        'House',
        foreign_keys=[house_id],
    )
    mouse = db.relationship(
        'House',
        foreign_keys=[mouse_id],
    )

    def __repr__(self):
        return f'<Person id={self.id} name={self.name} parent_id={self.parent_id} other_id={self.other_id}>'


class House(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    
    house_people = db.relationship('Person', foreign_keys='Person.house_id')
    mouse_people = db.relationship('Person', foreign_keys='Person.mouse_id')

https://docs.sqlalchemy.org/en/latest/orm/join_conditions.html