attributes
里面可以写sql查询语句!
ModelA.findAll({
attributes: [
'id',
'name',
[Sequelize.literal(`(
SELECT COUNT(*)
FROM tableB AS tableB
WHERE
tableB.foreign_id = tableA.id
)`),
'count']
],
where:{
//....
},
})
result
[
{id: '',name: '',count: ''},
{id: '',name: '',count: ''},
]
不知道这样是否能满足你的查询需求!
参考链接 Sub Queries
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…