mybaties 批量操作
void add(@Param("list") List<String> list, @Param("userId") Integer id);
<insert id="add">
insert into table_name(report_id,dept_id,parent_id) SELECT id,#{userId},parent_id from table_name2 where id IN
<foreach collection="list" item="id" index="index" open="(" close=")" separator=",">
#{id}
</foreach>
</insert>