how to build this nested query using laravel eloquent

SELECT *  FROM posts WHERE user_id IN (SELECT follower_id FROM followers where id =$id)OR user_id=$id;

MichalOravec

4 years ago

Best Answer

Level 75

$posts = Post::whereIn('user_id', function ($query) use ($id) {
    $query->select('follower_id')
        ->from('followers')
        ->where('id', $id);
})->orWhere('user_id', $id)->get();

1 like

Please or to participate in this conversation.