如何使用group_by在sqlalchemy中以字典/属性的形式访问"count“值？

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.sql import func

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

# 创建基类
Base = declarative_base()

# 定义模型类
class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    age = Column(Integer)

# 查询并分组
result = session.query(User.name, func.count(User.id)).group_by(User.name).all()

# 将结果转换为字典
result_dict = {name: count for name, count in result}

# 以字典形式访问"count"值
print(result_dict['John'])  # 输出John的count值

# 以属性形式访问"count"值
for name, count in result:
    print(name, count)  # 输出每个name和对应的count值