mapper.java

List<User> selectUserByIds(Long[] userIds);

mapper.xml

   <select id="selectUserByIds" parameterType="Long" resultMap="UserVoResult">
        select u.user_id, u.user_name,u.office_city
        from user u
        <where>
            u.status = '0'
            and u.user_id in
            <foreach collection="array" item="item" open="(" separator="," close=")">
                #{item}
            </foreach>
        </where>
        <foreach collection="array" item="item" open="order by field(u.user_id," separator="," close=")">
            #{item}
        </foreach>
    </select>