How to add multiple AND conditions in laravel query?

You can use sub-queries in anonymous function like this:

$results = User::where('this', '=', 1) ->where('that', '=', 1) ->where(function($query) { /** @var $query Illuminate\Database\Query\Builder */ return $query->where('this_too', 'LIKE', '%fake%') ->orWhere('that_too', '=', 1); }) ->get();

By Laravel Interview Questions

$query->where([
            ['col1', '=', 'val1'],
            ['col2', '=', 'val2'],
        ])->get()