Cacher is the code snippet organizer for pro developers

$posts = Post::leftJoin('comments', 'comments.post_id', '=', 'posts.id')
    ->selectRaw(
        'posts.*,
        count(comments.id) as comments_count'
    )
    ->groupBy('posts.id')
    ->orderBy('comments_count', 'desc')
    ->get();