PHP

eloquent complex queries

public function clicksCount(){
    return $this->hasOne('AppModelsEloquentClick')
                ->select(DB:raw("user_id, COUNT(*) count"))
                ->groupBy("user_id");
}

public function getClicksCountAttribute(){
    return $this->clicksCount->count();
}

eloquent complex queries

$user = User::find("user_id")->with('clicks')->get();
$clicks = $user->clicks()->count();