node中mysql批量查询

查询mysql数据库

anyDoctorByIds: async function(arr){
    let pool = await mysql.pool("sql_main");
    let sql ='SELECT * FROM doctor_account WHERE id IN ('+ arr +')';
    return await mysql.query(pool, sql, []);
  },

在controller中

                     var doctor =  await hospitalDao.anyDoctorByIds("'14345262900310','1428658311672','1428657273817','15439906369986','14569899662405','14358811489424','15731799635497','14560550152247','15440807537797','15467425112312','15097079998657'");