I need to know the Laravel Eloquent syntax for querying the nested relationship and returning the results

Question

I have the following models

• Company
• Contact
• Ticket
• Job
• User

Job BelongsTo Ticket, Ticket BelongsTo Contact or User (Polymorphic), Contact Belongs to Company. I can retrieve all jobs for a particular company with

Company::with('contacts.tickets.jobs')->where('id', 10)->get();

I want a list of all the jobs in the system for a particular company. I have tried the following, but it's not working, it is returning all Jobs

Job::with(['ticket' => fn($b) => $b->whereHasMorph('creator', [App\Contact::class],fn($b) => $b->where('company_id', 10))])->get();

Answer 1

$companyId = 6;

Job::whereHas('ticket', fn($b) => 
    $b->whereHasMorph('creator', [App\Contact::class], fn($c) => 
        $c->where('company_id', $companyId)
    )
   )->with(['ticket.creator.company'])->get();