sqlalchemy多表联合查询(join)

instances = db.session.query(Instance.name, Instance.sep_status, User.email).outerjoin( User, Instance.user_id==User.id).filter(Instance.is_terminated==0)
        for instance in instances.all():
        pass