python sqlalchemy 连接查询

多张表连接查询

sys_user_list = SysUser.query.join(sys_user_role).join(Role)\
            .filter(or_(Role.role == 'scrum_dev', Role.role == 'scrum_admin')).all()