对user_id进行分组,然后找到最大的date

select user_id, max(date)
    from login
    group by user_id
    order by user_id;