sequelieJS選取數(shù)據(jù)庫語句

    
    await organizationModel.findAll({
        where:{
            name: {
                $like: 'ext-%'
            }
        }
    }).then(ori => {
        // 這里需要修改，不能循環(huán)查詢數(shù)據(jù)庫
        Array.from(ori).forEach(record => {
            return userOrganizationModel.findAll({
                where: {
                    'organization_id':record.id
                }
            }).then(result => {
                console.log(result);
                ctx.json({
                    status: 100,
                    result
                });
            })
        });
        
    }).catch(err => {
        console.log(err);
        ctx.json({
            status: 101
        });
    });

};

const Sequelize = require('sequelize');
const sequelize = new Sequelize(...);

sequelize.query( //原始查詢
     'select * from user_organization where organization_id in(select id from organization where name like 'ext-%')' ,
     { type:Sequelize.QueryTypes.SELECT }
);

或者分兩步簡單查詢：

const ids = await DBmodel.Organization.findAll({
    where: { name: {$like: 'ext-%'} },
    attributes: ['id']
})
const result = await DBmodel.User_organization.findAll({
    where: {
        organization_id: {$in: ids}
    }
})