有没有办法在合计数的时候保留其他字段值

Question

1.比如N个销售订单，我想统计每天每个商品的销售额，但是如果用sum（）求和，会把我其他字段都删掉，有没有什么办法可以保留字段，并且求和

2.原始数据

$data = array(
                array(
                        'date' => 2019-01-01,
                        'goods' => 鼠标,
                        'num' => 1,
                        'price' => 50.00,
                    ),
                array(
                        'date' => 2019-01-01,
                        'goods' => 键盘,
                        'num' => 1,
                        'price' => 70.00,
                    ),
                 array(
                        'date' => 2019-01-01,
                        'goods' => 键盘,
                        'num' => 1,
                        'price' => 70.00,
                    ),
                 array(
                        'date' => 2019-01-02,
                        'goods' => 鼠标,
                        'num' => 1,
                        'price' => 50.00,
                    ),
         );

我想要的结果是

2019-01-01 = array(
                array(
                        'date' => 2019-01-01,
                        'goods' => 鼠标,
                        'num' => 1,
                        'price' => 50.00,
                    ),
                array(
                        'date' => 2019-01-01,
                        'goods' => 键盘,
                        'num' => 2,
                        'price' => 140.00,
                    ),
                 );
2019-01-02 = array(
                 array(
                        'date' => 2019-01-02,
                        'goods' => 鼠标,
                        'num' => 1,
                        'price' => 50.00,
                    ),
         );

Answer 1

select sum(num),sum(price),date,goods group by date,goods
对num和price求和，对date和goods分组