laravel 5.2嵌套Where子句

Question

How to perform a where clause using laravel eloquent with the following query:

select * from stats where payed = 1 AND WHERE (user_id = 1 OR owner_id = 1)

I don't know how to modify this code for this:

    $payouts = Stat::where('payed', '1')
            ->???(function ($query) {
                $query->where('owner_id', Auth::user()->id)
                      ->where('user_id', Auth::user()->id);
            })->get();

Answer 1

Change like this

$payouts = Stat::where('payed', '1');
        $payouts->where(function ($payouts) {
            $payouts->where('owner_id', Auth::user()->id)
                  ->orWhere('user_id', Auth::user()->id);
        })->get();