Laravel get data with belongsto column

plans table columns
id, name, type

clients table columns
id, name, plan_id

// for client

function plan()
return $this->belongsTo(Plan::class, 'plan_id', 'id');



I input plan_id to Clients table

I want to get those clients data from clients table if plan type ='PP'

$clientData = Client::with(['plan' => function ($clientData)
$clientData->where('type', 'PP');
)->get();


I tried this but I got all data from clients table.

1 Answer
1

->with() doesn't constrain the data from the initial query, it just eager loads it. You need to use ->whereHas() for that:

->with()

->whereHas()

$clientData = Client::with(["plan"])
->whereHas("plan", function ($query)
$query->where("type", "=", "PP");
)->get();


This will only return Client records that have a Plan with a type of PP.

Client

Plan

PP

->whereHas()

Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

Required, but never shown

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.