mysql in 子条件中不支持limit

mysql in 子条件中不支持limit ，再嵌套一层即可

where corp_id=#{corpId} and person_id=#{personId} and end_atten_date>#{endAttenDate}

and uuid not in(select uuid from (select * from hr_time_person_atten where corp_id=#{corpId} and person_id=#{personId} order by end_atten_date asc limit 1) as t );