分割逗号成list查询

<select id="getUserListByUsernames" parameterType="java.lang.String"  resultType="org.jeecg.modules.system.entity.SysUser">
        select * from  sys_user  where username in
        <foreach item="item" index="index" collection="usernames.split(',')"  open="(" separator="," close=")">
            '${item}'
        </foreach>
         and del_flag = '0'
    </select>