SELECT u.`user_id`, u.`price`, u.`date`
FROM `users` u JOIN
(SELECT `user_id`, max(`date`) as `mtime` FROM `users` GROUP BY `user_id`) as t1
ON u.`user_id`= t1.`user_id` AND u.`date` = t1.`mtime`;
Воооот так вот :)