如何使用 Laravel Eloquent 创建多个 Where 子句查询？

假设我们有这么一个例子：

$results = User::where('this', '=', 1)
    ->where('that', '=', 1)
    ->where('this_too', '=', 1)
    ->where('that_too', '=', 1)
    ->where('this_as_well', '=', 1)
    ->where('that_as_well', '=', 1)
    ->where('this_one_too', '=', 1)
    ->where('that_one_too', '=', 1)
    ->where('this_one_as_well', '=', 1)
    ->where('that_one_as_well', '=', 1)
    ->get();

它有效，但并不优雅。我们可以使用更细化的 wheres 作为数组传递：

$query->where([
    ['column_1', '=', 'value_1'],
    ['column_2', '<>', 'value_2'],
    [COLUMN, OPERATOR, VALUE],
    ...
])

只要我们想要所有的wheresuseand运算符，我们都可以这样分组：

$matchThese = ['field' => 'value', 'another_field' => 'another_value', ...];

$orThose = ['yet_another_field' => 'yet_another_value', ...];

然后：

$results = User::where($matchThese)->get();
$results = User::where($matchThese)->orWhere($orThose)->get();

以上将导致这样的查询：

SELECT * FROM users
  WHERE (field = value AND another_field = another_value AND ...)
  OR (yet_another_field = yet_another_value AND ...)