public function clubStatus($bookClubId) { $result = []; $statuses = collect(); $bookclubs = $this->bookclubs()->where('book_club_id', $bookClubId)->get()->groupBy('pivot.status_id'); foreach ($bookclubs->toArray() as $key => $value) { $key = \App\BookStatus::findOrFail($key)->name; $statuses->put($key, count($value)); } return $statuses; }