foo.php

ServiceQuery::create()
  ->join('ServiceWeb', 'INNER JOIN')
  ->join('ServiceWeb.ServiceWebDomain', 'LEFT JOINT')
  ->join('ServiceWeb.ServiceWebHosting', 'LEFT JOIN')
  ->withColumn('COUNT(DISTINCT(ServiceWeb.ID))', 'accounts')
  ->withColumn('COUNT(DISTINCT(ServiceWebDomain.ID))', 'domains')
  ->withColumn('COUNT(DISTINCT(ServiceWebHosting.ID)), 'hosting')
  ->select(array('accounts', 'domains', 'hosting'))
  ->find();