$groupedSalesCampaign = Order::with('Campaign') ->where('isapproved','=','Y') ->groupBy('campaign_id') ->orderBy(DB::raw('COUNT(id)','desc')) ->get(array(DB::raw('COUNT(id) as totalsales'),'campaign_id'));