query builder laravel select all where code example

Example: laravel query builder select first

$user = DB::table('users')->where('name', 'John')->first();

var_dump($user->name);