mysql查询重复数据，限制条数

SELECT * FROM `order` a WHERE (
 SELECT COUNT(1) FROM `order` b WHERE b.user_id = a.user_id AND b.id > a.id 
) < 5
ORDER BY user_id ASC, order_date DESC