query("SELECT c.*, COUNT(cars.id) as car_count FROM categories c LEFT JOIN cars ON c.id = cars.category_id AND cars.status = 'Active' GROUP BY c.id ORDER BY c.name"); $categories = $stmt->fetchAll(); ?>