$db = db('product');
$app_db = db('productapp');
$where = array();
$where['userid'] = ['=',session('indexUserID')];
$list = $db->where($where)->paginate(10);
$list->toArray();
foreach($list as $k=>$v){
$whereApp = array();
$whereApp['pid'] = ['=',$v['pid']];
$whereApp['state'] = ['=',1];
$app = $app_db->where($whereApp)->field('sum(apptype) as appNum')->find();
$appNum = $app['appNum'];
$dataAry['appNum'][$v['pid']] = $appNum;
$data = array();
$data = $v;
$data['appNum'] = $appNum;
$list->offsetSet($k,$data);
}