TP5.0group分组并获取组内最新数据

• 构建查询语句

$Query  = Db::table("group_table")
		->where(['status'=>'1'])
		->order(['created_at'=>'desc'])
		->limit(1000000000)// 不加这行无法出现最新数据
		->buildSql();//构建查询语句
           

• 分组

$group = Db::table($query."a")
		->field("a.id,count(a.id) as count,a.member_id,a.content,a.status")
		->order(["created_at"=>"desc"])
		->group("member_id")
		->select();
           

• 分组并分页

$group = Db::table($query."a")
		->field("a.id,count(a.id) as count,a.member_id,a.content,a.status")
		->order(["created_at"=>"desc"])
		->group("member_id")
		->paginate(10,false,['page'=>1]);