mysql group by 需要获取最后一条数据

      $user_sql = "select mid,year(from_unixtime(ref_date)) as year,month(from_unixtime(ref_date)) as month,user_source as all_user ";
        //综合
        $order_by_sql = " (select user_source,mid,ref_date from mr_user_summary_data order by ref_date DESC) u ";

        $user_data = Db::query($user_sql." from ".$order_by_sql."  group by mid, year(from_unixtime(ref_date)), month(from_unixtime(ref_date))  ");

grpup by 默认获取第一条数据 。用这个 方法可以获取最后一条数据