Laravel Eloquent Eager Loading - Passing Parameters and Data to With Related Queries and Models

laravel-eager-passing-parameters.php

<?php

  // must first define the relationships between your models
  // see here: https://laravel.com/docs/5.3/eloquent-relationships#eager-loading

	$result = Topic::where( 'slug', $slug )->approved()->with([
	    'comments' => function( $query ) use ( $data ) {
		$query->take( $data['limit'] )
		    ->skip( $data['limit'] * ( $data['page'] - 1 ) )
		    ->with('user.profile')
		    ->orderBy('comments.id','desc');
	    }
	])->first();