Ordering a pagination by a relationship (Laravel 5.3)

In my app I have posts. I wish to show all the posts on the homepage, but order them higher if the post's user has uploaded an image. I can determine if the post's user has uploaded an image by checking if the user has a relationship with a row in the images table, like this:

$post->user->image 

My code currently looks like this:

$posts = Post::where('subject_id', '=', $subject->id)
        ->approved()
        ->orderBy('created_at', 'desc')
        ->paginate(18);

Currently, I am simply ordering it by created at, but ideally all posts whose related user has an image will come first, then the rest. I've been looking for a way to do this efficiently and in a way that doesn't just work on the first page.

How should I go about this?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2kXwOcW
via IFTTT