query function laravel with relationship

   $other_count = UserActivity::where('user_id', $user_id)

        ->whereBetween('activity_date', [$start_date, $end_date])
        ->where('activity_type', '!=', 1)
        ->where('activity_type', '!=', 2)
        ->where('annual_training_program_id', $request->annual_training_program_id)
        ->where('annual_training_program_week_id', $request->annual_training_program_week_id)
        ->whereHas('activity',function($q){
            $q->whereNull('sport_id');
        })

Hello
->whereHas('activity')
activity is the relation name

Comments