// mapperList<User>userNum(@Param("userClass")List<Integer> userClass);// xml<!--循环查询--><select id="userNum" resultType="com.xxx.xx.vo.User">
select u.* from t_user u
LEFT JOIN dept d ON d.id = u.pid
where
in <foreach item='item' index='index' collection='atpTypes' open='(' separator=',' close=')'>#{item}</foreach></select>