如何在zend frame work2中编写带有左连接的计数查询？

use Zend\Db\Sql\Select;
use Zend\Db\Sql\Expression;

// 创建一个Select对象
$select = new Select();
$select->from('table1')
       ->columns(array('count' => new Expression('COUNT(table1.id)')))
       ->join('table2', 'table1.id = table2.table1_id', array(), Select::JOIN_LEFT);

// 获取查询结果
$resultSet = $adapter->query($select->getSqlString($adapter->getPlatform()), $adapter->getResultPrototype());
$count = $resultSet->current()['count'];

// 打印计数结果
echo "Count: " . $count;