Array
(
    [field] => *,
      ( SELECT COUNT(category_id) FROM wps_categories AS b WHERE b.parent_id=a.category_id ) 
      AS total_subcategories
    [condition] => AND category_id = '406' AND status='1' 
    [debug] => 
)