如何查询属于特定父级的子表

是否有可能在一对多层次结构中获取一个/所有深嵌套子表？

假设一个用户已经登录。

u = db.session.execute(db.select(U).where(U.email == '[email protected]')).scalar()

我想查询X3用户中的一个/所有表。该怎么做？

                    <- X3 ->
    <- X1 -><- X2 ->
                    <- X3 ->
-- U1 ->
                        <- X3 ->
        <- X1 -><- X2 ->
                        <- X3 ->

--------------------------------

                        <- X3 ->
        <- X1 -><- X2 ->
                        <- X3 ->
-- U2 ->
                        <- X3 ->
        <- X1 -><- X2 ->
                        <- X3 ->

class U(UserMixin, db.Model):
    id: Mapped[int] = mapped_column(primary_key=True)
    email: Mapped[str] = mapped_column(String(64), index=True, unique=True)
    # ...
    x1: Mapped[list["X1"]] = db.relationship(back_populates="u", cascade='all, delete')

class X1(db.Model):
    id: Mapped[int] = mapped_column(primary_key=True)
    # ...
    u: Mapped["U"] = db.relationship(back_populates="x1", cascade='all, delete')
    u_id: Mapped[int] = mapped_column(ForeignKey("u.id"))
    x2: Mapped[list["X2"]] = db.relationship(back_populates="x1", cascade='all, delete')

class X2(db.Model):
    id: Mapped[int] = mapped_column(primary_key=True)
    # ...
    x1: Mapped["X1"] = db.relationship(back_populates="x2", cascade='all, delete')
    x1_id: Mapped[int] = mapped_column(ForeignKey("x1.id"))
    x3: Mapped[list["X3"]] = db.relationship(back_populates="x2", cascade='all, delete')
    
class X3(db.Model):
    id: Mapped[int] = mapped_column(primary_key=True)
    # ...
    x2: Mapped["X2"] = db.relationship(back_populates="x3", cascade='all, delete')
    x2_id: Mapped[int] = mapped_column(ForeignKey("x2.id"))

谢谢。