https://blog.csdn.net/qq_36688928/article/details/82783392
// 根据菜单id列表查询菜单数据 List<SysMenuEntity> findByIds(List<Long> menuIds);
<select id="findByIds" resultType="com.shengquan.wateradmin.entity.SysMenuEntity"> select * from sys_menu <where> menu_id in <foreach item="item" index="index" collection="list" open="(" separator="," close=" )">#{item} </foreach> </where> </select>