CODE EXAMPLE FOR 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();
}