SQLAlchemy根据其他表的字段过滤查询结果

from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    addresses = relationship("Address", back_populates="user")

class Address(Base):
    __tablename__ = 'addresses'
    id = Column(Integer, primary_key=True)
    email_address = Column(String, nullable=False)
    user_id = Column(Integer, ForeignKey('users.id'))
    user = relationship("User", back_populates="addresses")
    city = Column(String)

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

# 创建数据库引擎和会话
engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
session = Session()

# 查询地址表中城市为"北京"的用户
users = session.query(User).join(Address).filter(Address.city == "北京").all()

# 打印查询结果
for user in users:
    print(user.name)