php - Laravel Union "Call to a member function union() on int"

Question

Error: Call to a member function union() on int

$category = Category::select('name')->count();
$city = City::select('city')->count();
$client = Client::select('name')->count();

$property = Property::select('name')->count()
                    ->union($category)
                    ->union($city)
                    ->union($client)
                    ->get();

dd($property);

question from:https://stackoverflow.com/questions/65865774/laravel-union-call-to-a-member-function-union-on-int

Answer 1

If you just want an array of counts, union won't work for you. Select count(*) from multiple tables

$counts = [
    'city' => City::count(),
    'category' => Category::count(),
    'client' => Client::count(),
    'property' => Property::count(),
];

There's no need to keep it in one query.