如何在Flask-Admin中显示角色与用户的关系？

from flask_admin.contrib.sqla import ModelView
from flask_admin import Admin
from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'your_database_uri'
db = SQLAlchemy(app)
admin = Admin(app)

# 创建角色模型
class Role(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50), unique=True)
    description = db.Column(db.String(200))

# 创建用户模型
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    email = db.Column(db.String(100), unique=True)
    password = db.Column(db.String(100))
    role_id = db.Column(db.Integer, db.ForeignKey('role.id'))
    role = db.relationship('Role', backref=db.backref('users', lazy='dynamic'))

# 创建关联表
user_role = db.Table('user_role',
    db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
    db.Column('role_id', db.Integer, db.ForeignKey('role.id'))
)

# 注册模型到Flask-Admin
admin.add_view(ModelView(Role, db.session))
admin.add_view(ModelView(User, db.session))

# 自定义视图
class CustomModelView(ModelView):
    def get_list(self, page, sort_column, sort_desc, search, filters, execute=True, page_size=None):
        # 查询关联表中的数据
        query = db.session.query(User, Role).join(user_role).join(Role)
        return super(CustomModelView, self).get_list(page, sort_column, sort_desc, search, filters, execute, page_size)

# 注册自定义视图
admin.add_view(CustomModelView(User, db.session))

if __name__ == '__main__':
    app.run()