$db = DB::table('user'); $db->orderBy(字段,"desc"); $db->groupBy(字段)->having('参数','条件',数值)->get();//havingRaw(原生条件) $db->skip(3)->take(5);//限定,跳过3条取5条