python sqlalchemy 連接配接查詢

多張表連接配接查詢

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