sequelize 联合查询

Question

我用sequelize 联合查询

 db.user.hasMany(db.bbsuser,{foreignKey:'userId'});
 db.bbsuser.belongsTo(db.user);

 db.user.findAll({include:[db.bbsuser]})；

得到结果格式以下：

{
    "id": 9,
    "username": "CallMeSoul",
    "truename": "陈译彬a",
    "phone": "18825111542",
    "eamil": "",
    "sex": 9,
    "avatar": "http://wx.qlogo.cn/mmopen/LMZxJ2ofzuHgXWBvfrLfRrCibZ5I14KYWHlfA7AQicVOWZPWJl1K0icXM6AKZCiaY0pUyyoIHfDqf6ppXdpRLJSaLiacsbfhpdoPp/0",
    "token": "",
    "balance": 0,
    "integral": 201,
    "state": 9,
    "country": "中国",
    "province": "广东",
    "city": "中山",
    "openid": "oFMa7wNAA9zBgboSZm0dm9AdweLE999",
    "createtime": null,
    "udpatetime": null,
    "bbsusers": [
        {
            "id": 22,
            "userId": 9,
            "bbsId": 3,
            "isAdmin": 0,
            "createTime": "2017-01-12T14:49:52.000Z"
        }
    ]
}

但我想查出bbsId=3,的所有结果要怎么添加where语句呢？
我试过以下都不行：

 db.user.findAll({where:{bbsId:4},include:[db.bbsuser]})；
 db.user.findAll({include:[db.bbsuser],{where:{bbsId:4}})；

Answer 1

db.user.findAll(
    {
        include:[
            {
                model:db.bbsuser,
                as:'bbsuser',
                where:{
                    bbsId:4
                }
             }
         ]});