Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
I am developing a real estate site. It has the concept of INNER CIRCLES which has a user as an ADMIN and users can join different CIRCLES. I need to show total number of users ( including ADMIN ) in a CIRCLE , the total number of LISTINGS by all the CIRCLE members and total number of LISTINGS by all the members which are CLOSED.
Controller :
public function MemberInnerCircles()
{
$user = Auth::user();
$memberof = InnerCircleMember::where('member_id', $user->id)->where('status', 1)->paginate(10);
return view('frontend.innercircle.memberinnercircles', compact('memberof', 'user'));
} // end method
model:
class InnerCircleMember extends Model
{
use HasFactory;
protected $guarded = [];
public function member(){
return $this->belongsTo(User::class,'member_id');
}
public function circle(){
return $this->belongsTo(InnerCircle::class,'circle_id');
}
}
What will be my query ?
$circles = InnerCircleMember::withCount('members')->get();
You should get the number as $circles[0]->members_count
If you want to add to your current query
$memberof = InnerCircleMember::withCount('members')->where('member_id', $user->id)->where('status', 1)->paginate(10);
@MohamedTammam Thanks for your precious time.
But how to get number of listings by members of a circle ?
@FounderStartup I don't understand the question, can you please explain more?
@MohamedTammam This is what exactly I need :
I am developing a real estate site. It has the concept of INNER CIRCLES which has a user as an ADMIN and users can join different CIRCLES.
@FounderStartup What is "listing"?
@MohamedTammam 'listing' is property listing by users.
@FounderStartup Does user model have a relationship called listing?
NO
model : User
public function circlemember() { return $this->hasMany(InnerCircleMember::class, 'member_id', 'id'); }
model listings has a relation :
public function user(){ return $this->belongsTo(User::class,'user_id','id'); }
@FounderStartup In your InnerCircleMember model You can add hasManyThrough relationship
class InnerCircleMember extends Model
{
public function listings()
{
return $this->hasManyThrough(listing::class, User::class);
}
}
And use withCount with that relationship also.
InnerCircleMember::withCount(['members', 'listings']) // ...
https://laravel.com/docs/9.x/eloquent-relationships#has-many-through
@MohamedTammam Getting this error :
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.inner_circle_member_id' in 'where clause'
@FounderStartup Define your relationship according to the docs: https://laravel.com/docs/9.x/eloquent-relationships#has-many-through
@MohamedTammam OK. Thanks for your precious time.
Please or to participate in this conversation.