楼盘表(lgz_house)
楼盘成交表(lgz_house_trading)
现在要查的是,楼房表的里面每个楼房有多少个成交的楼盘
原生sql语句如下
select lgz_house.*,(select count(lgz_house_trading.id) from lgz_house_trading where lgz_house.id=lgz_house_trading.house_id) num from lgz_house
得到打印的结果
标注的就是统计出来的成交数量
TP5框架可以如下写法
//原生语句
$sql = 'select lgz_house.*,(select count(lgz_house_trading.id) from lgz_house_trading where lgz_house.id=lgz_house_trading.house_id) num from lgz_house';
$data1 = Db::query($sql);
//链式操作
$data = Db::name('house')
->field('*,(select count(lgz_house_trading.id) from lgz_house_trading where lgz_house.id=lgz_house_trading.house_id) num')
->select();