Is there any way to keep the values of other fields when counting?

1. For example, for N sales orders, I want to count the sales of each item every day, but if I use sum () to sum, I will delete all my other fields. Is there any way to keep the fields and sum

2. Raw data

$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,
                    ),
         );

the result I want is

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,
                    ),
         );
Jul.06,2022

select sum (num), sum (price), date,goods group by date,goods
summation of num and price, grouping date and goods

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bf8140-320cb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bf8140-320cb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?