Laravel Eloquent - “whereNotIn”使用子查询？

I'm struggling to figure out how I can use this SQL with eloquent methods.

SELECT * FROM artists WHERE artists.id NOT IN
(SELECT artist_id FROM artist_issues WHERE issue = 'update_images')

I see that the "whereNotIn" method takes a column, and then an array as the second parameter, so it's not possible to pass a subquery.

Any ideas how I could do this?

Thanks.

Assuming you have the correct relationships set, it should be something like this:

$artists = Artist::whereHas('artist_issues', function(q) {
   $q->where('issue', '<>', 'update_images');
});

I guess you have something like this in your Artist model:

public function artist_issues()
{
    return $this->belongsTo('App\ArtistIssue');
}