【Python】sqlalchemy 实现同一表 多级inner join

表结构

表名： vaguelabeluser  用户模糊标签表

字段：

vaguelabel_id 标签id

user_id  用户id

value 标签的值

原sql语句

select b.user_id from 

(vaguelabeluser b inner join vaguelabeluser a on a.user_id=b.user_id)

inner join vaguelabeluser c on b.user_id = c.user_id

where (b.vaguelabel_id=7 ) and (a.vaguelabel_id=2) and (c.vaguelabel_id=3)

group by b.user_id;

Python语句

from app.BehaviorLabels import sqlModel  #自己写的，详见下方【附录1】

from from sqlalchemy import create_engine, and_, or_

from sqlalchemy.orm import sessionmaker,aliased

# 链接数据库

engine