SQL

laravel get sql query eloquent with parameters

$query->toSql();

$query->getBindings()

laravel get query parameters

$name = $request->query('name', 'Helen');

laravel eloquent with query parameter

$campaign = Campaign::find($campaign_id);
    $buyers = $campaign->buyers()->with('notes')->with(['emails' => function($q) use ($campaign_id){
        $q->where('campaign_id', $campaign_id);
    }])->get();