$where = $this->getWhere($request);
$join = [
['__CRM_CONTRACT__ contract', 'contract.contract_id = a.contract_id', 'LEFT'],
['__ADMIN_USER__ user', 'user.id = contract.owner_user_id', 'LEFT'],
['__CRM_PRODUCT__ product', 'product.product_id = a.product_id', 'LEFT'],
['__CRM_PRODUCT_CATEGORY__ product_category', 'product_category.category_id = product.category_id', 'LEFT'],
];

$list = db('crm_contract_product')
->alias('a')
->where($where)
->join($join)
->group('a.product_id')
->field('a.product_id,sum(a.num) as num,product_category.name as category_id_info,product_category.category_id')
->select();
return $list;

这段代码执行后是这样结果：

想得到这样的结果该如何修改：


表结构