用子查询吧，
select * from user where date = (select date from user order by date desc limit 1)