yii2.0根据日期分组，查询用户的消费记录

这是数据库，时间是时间戳的格式。

希望展示成这样的，把用户同一天的消费记录整合起来，计算消费总金额。

$recordList=(new yii\db\Query())
		->select(['FROM_UNIXTIME(ctime, \'%Y-%m-%d\') AS date','sum(money) as total_money'])
		->from('customer_pay_log')
		->where(['customer_id'=>$userInfo->depend_id])
		->addGroupBy(['FROM_UNIXTIME(ctime, \'%Y-%m-%d\')'])
		->offset($offset)
		->limit($limit)
		->orderBy(['FROM_UNIXTIME(ctime, \'%Y-%m-%d\')' => SORT_DESC])
		->all();
		foreach($recordList as $k =>$v){

			$recordList2 = CustomerPayLog::find()
			->where(['customer_id'=>$userInfo->depend_id,'FROM_UNIXTIME(ctime, \'%Y-%m-%d\')' =>$v['date']])
			->asArray()
			->all();
			$recordList[$k]['list'] =$recordList2;
		}

FROM_UNIXTIME 将时间戳转换为日期格式
思路是先将数据根据日期去重查询，查出哪些日期有过消费记录，再根据日期循环查询每天的数据

{
				"date": "2020-07-27",
				"total_money": "2200.00",
				"list": [
					{
						"id": "4891f23195b04fd3a7de29eafe2514ac",
						"shop_id": "1db05cf51f508135a8300d7740dcec4a",
						"customer_id": "03ef28ae402752599e75b87c0a237bbb",
						"content": "1111",
						"money": "2200.00",
						"remark": "啊啊啊啊啊",
						"ctime": "1595832193"
					}
				]
			},
			{
				"date": "2020-07-10",
				"total_money": "168.00",
				"list": [
					{
						"id": "7c481ed9dab93eb133557872de80661e",
						"shop_id": "1db05cf51f508135a8300d7740dcec4a",
						"customer_id": "03ef28ae402752599e75b87c0a237bbb",
						"content": "眼镜消毒液*2瓶",
						"money": "40.00",
						"remark": "测试数据，请勿当真",
						"ctime": "1594367894"
					},
					{
						"id": "8636201fd8ede6cc684d8f8b0ddffb13",
						"shop_id": "1db05cf51f508135a8300d7740dcec4a",
						"customer_id": "03ef28ae402752599e75b87c0a237bbb",
						"content": "XX牌隐形眼镜-日抛型-6片",
						"money": "128.00",
						"remark": "测试数据，请勿当真",
						"ctime": "1594367689"
					}
				]
			}

结果如上所示，将数据按照日期来组成新的数组。