I need equivalent eloquent query

The steps below solves it but I want it to be just one process:

$ids= DB::table('projects')->selectRaw('COUNT(*) as count, worker_id') ->where('status', 2) ->having('count', '>', 2) ->groupBy('worker_id') ->pluck('worker_id');

        $users= User::whereIn('id', $ids)
        ->get();

You can use whereIn

$users = DB::table('users')
                    ->whereIn('id', [1, 2, 3])
                    ->get();

and havingRaw

$orders = DB::table('orders')
                ->select('department', DB::raw('SUM(price) as total_sales'))
                ->groupBy('department')
                ->havingRaw('SUM(price) > ?', [2500])
                ->get();

and subqueries

$users = User::where(function ($query) {
    $query->select('type')
        ->from('membership')
        ->whereColumn('user_id', 'users.id')
        ->orderByDesc('start_date')
        ->limit(1);
}, 'Pro')->get();

All the code examples are from the docs.

https://laravel.com/docs/7.x/queries

whereIn takes an anonymous function as a subquery

you should be able to do something like this:

$users= User::whereIn('id', function ($q) {
	$q->select('worker_id')->from('projects')->where('status', 2) ->havingRaw('COUNT(*) > 2') ->groupBy('worker_id');

})->get();

Not tested

@beyond Why did you make another thread for the same question?

https://laracasts.com/discuss/channels/eloquent/this-query-with-eloquent

I'm sorry, I had no reply. And u thought about chances of getting answers from laravel category due to the traffic here.

@tray2 @edoc I really appreciate your contributions. Thanks

But I gave the exact same reply on that other post. But rather than copying and pasting the examples I referred you to the query Builder chapter which has all of those examples. So I'm confused on why you said you didn't get no reply.

@TaylorOtwell included many great examples to learn from all through the documentation.

But no worries, everything is okay.