SELECT mp.institute_id,
    mp.category_id,
    mp.mapp_branch_id,
    mp.mapp_product_id
FROM mapping_with_products mp
LEFT JOIN categories cat ON cat.id = mp.category_id
WHERE mp.mapp_product_id IN ( 5 ,12 ,34 ,90 ,123 )
ORDER BY mp.category_id DESC

（in）函数不使用联接，执行查询但不显示数据，我已经选中了，数据Map为给定的id