I am trying to get the value of the colum "name" from the clubs table.

**First table:(Clubs)**

* id\*
* name ***(what i need!!!)***
* email
* password

**Second table:(club\_posts)**

* id
* club\_id\*
* zip\_id
* kategory
* type
* stadt
* plz

**Controller:**

```
public function search(Request $request)
{
    $zip = $request->input('zip');

        $users = Post::where('zip_id', 'like', $zip)
                        ->orderBy('date')
                        ->paginate(25);

        $clubs = ClubPost::where('zip_id', 'like', $zip)
                        ->orderBy('updated_at')
                        ->paginate(25);

        $city = Zip::where('zip_code', 'like', $zip)
                        ->value('city');

```

**This is my query:**

```
        $names = Club::select('name')
                        ->leftJoin('club_posts', 'club_id', '=', 'clubs.id')
                        ->get();

```

```
        dd($names);

        return view('search.result', compact('users', 'clubs', 'city', 'names'));
    }

```

The result is an array with ten values, but need only one.[![enter image description here](https://i.stack.imgur.com/MhF9y.png)](https://i.stack.imgur.com/MhF9y.png)