Query relationship Eloquent

Any of these should work for you, pick the one you like the most:

1. Eager-loading.

   $comments = News::find(123)->with(['comments' => function ($query) {
       $query->where('trashed', '<>', 1);
   }])->get();
   

   You can inject the parameter to query function by use($param) method, that allows you to use dynemic query value at runtime.

2. Lazy-loading

   $news = News::find(123);
   $comments = $news->comments()->where('trashed', '<>', 1)->get();
   

---

I couldn't help but notice, though, that what you're probably trying to do is handle soft deleting, and that Laravel has built-in functionality to help you with that: http://laravel.com/docs/eloquent#soft-deleting

rmobis's answer was what I needed, but it throws an error in current Laravel 5. You have to use it as an associatve array now:

$comments = News::find(123)->with(
    ['comments' => function ($query) {$query->where('trashed', '<>', 1);}]
);

Took me some time to figure it out, hope this will help others.

Read more in Laravel's Docs (5.6): https://laravel.com/docs/5.6/eloquent-relationships#querying-relations

You can do simply in your eloquent model file. do like this :

public function comments_with_deleted()
{
    return $this->belongsTo('Comments', 'id')->where('deleted', 1);
}

public function comments()
{
    return $this->belongsTo('Comments', 'id');
}

call like this :

// for show comments with deleted
$comments = News::find(123)->with('comments_with_deleted');

// for show comments without deleted
$comments = News::find(123)->with('comments');