$query->with(['provider' => function code example

Example 1: wherein laravel

DB::table('user')->whereIn('id', [100,200])->get();

Example 2: laravel chunk select

DB::table('users')->chunk(100, function($users)
{
    foreach ($users as $user)
    {
        //
    }
});