SqlAlchemy :我要筛选2个外键上的查询

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy import and_

# 创建数据库引擎
engine = create_engine('数据库连接字符串')

# 创建会话
Session = sessionmaker(bind=engine)
session = Session()

# 定义表A和表B的模型类
class A(Base):
    __tablename__ = '表A'
    id = Column(Integer, primary_key=True)
    b_id = Column(Integer, ForeignKey('表B.id'))

class B(Base):
    __tablename__ = '表B'
    id = Column(Integer, primary_key=True)

# 查询同时满足两个外键的记录
query = session.query(A).join(B).filter(and_(A.b_id == B.id, A.b_id == 1))

# 执行查询并获取结果
results = query.all()

# 打印结果
for result in results:
    print(result.id)

# 关闭会话
session.close()