function index() { $adviceDetailTableName = AdviceDetail::getTableName(); $adviceTableName = Advice::getTableName(); $advices = Advice::leftJoin($adviceDetailTableName, $adviceDetailTableName . '.id_advice', '=', $adviceTableName . '.id')->groupBy($adviceTableName . '.id')->select([$adviceTableName . '.*', DB::raw("COUNT(DISTINCT {$adviceDetailTableName}.id_question) as sumQuestion")])->get(); $sumQuestion = Question::count(); return View::make('advice.index', ['advices' => $advices, 'sumQuestion' => $sumQuestion]); }