How to make such a query to the database?

Question

Laravel

There is a table of services and payment for the service, you need to find all the services that fit the parameters, and then select from these services only those that have made the payment.

$services = \DB::table('services_to')
            ->whereRaw('json_contains(categoriesId, \''.$categoryId.'\')')
            ->where('active', '=', 'Y')
            ->where('moderate', '=', 'Y')
            ->leftJoin('services_pay', function ($join)
            {
                $join->on('services_pay.service_id', '=', 'services_to.id')
                    ->where('pay_date', '<', strtotime(date('Y-m-d H:i:s')))
                    ->where('finish_date', '>', strtotime(date('Y-m-d H:i:s')));
            })
            ->take(20)
            ->get();

I make such a request, and it pulls all the where conditions in join

Answer 1

Remove all Where under Join ?