How to get Specific Columns Using “With()” Function in Laravel Eloquent
You may not always need every column from the relationships you are retrieving. For this reason, Eloquent allows you to specify which columns of the relationship you would like to retrieve:
$books = Book::with('author:id,name')->get();
also It can be done by passing a closure function in with() as second index of array like
Post::with(array('user'=>function($query){
$query->select('id','username','post_id');
}))->get();
It will only select id and username from other table.
Remember that the primary key (id in this case) needs to be the first param in the $query->select() to actually retrieve the necessary results.*
