Correct query to count with relation

I am working on a real estate site. Need the count of listings in a project ( building ) of a particular city.

 $listingcount = App\Models\Listings::where('project.city',$item->id)->count();

Listings model has a relation to project() and projects has a relation to city().

What is my correct query to count ?

Level 55

 $listingcount = App\Models\Listings::whereHas('project.city', fn($query) => $query->where('id', $item->id))->count();

or if project belongsTo city (has 'city_id' column)

 $listingcount = App\Models\Listings::whereHas('project', fn($query) => $query->where('city_id', $item->id))->count();

1 like

Level 5

Hey , thanks for your time. But its giving syntax error.

I tried this

$listingcount = App\Models\Listings::has('project.city',$item->id)->count();

The total count of listings is correct but the city is not correct.

Level 5

error

syntax error, unexpected '=>' (T_DOUBLE_ARROW), expecting ')'

Please or to participate in this conversation.