mysql - 如何解决选择查询问题中的限制？

Question

SQL 代码：

select
    car_id, user_id 
from
    orders o
left join
    users u on u.id =  o.user_id
where
    o.user_id in (select id from users limit 3)

mysql说This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery

标签： mysql