mysql 分组后时间没有按照最新时间倒序

SELECT
u.nickname,
u.head_img,
– 修改子查询，合并多个字段为一个字符串返回
(SELECT CONCAT(create_time, ‘|’, content, ‘|’, type)
FROM chat
WHERE from_id = 4 OR to_id = 4
ORDER BY id DESC
LIMIT 1) AS uinfo,
u.id AS user_id,
MAX(c.create_time) AS create_time
FROM chat c
LEFT JOIN user u ON (c.from_id = u.id AND c.to_id = 4 OR c.to_id = u.id AND c.from_id = 4)
WHERE (c.from_id = 4 OR c.to_id = 4)
GROUP BY u.id, u.nickname, u.head_img
ORDER BY create_time DESC
LIMIT 0, 10;

可以使用MAX()实现