public function chartMajor(Request $request) { $res = Record::selectRaw('count(*) as y, major as name'); $res = $res->groupBy('major'); return $res->get()->toJson(); }