SELECT COUNT(`read_status` = 0 OR NULL) AS newMessage,
receiver,TEXT,related_goods_id,u.`NICKNAME`,create_time
FROM
(SELECT to_user_id AS receiver,related_goods_id,TEXT,`read_status`,create_time FROM dialogue
WHERE
(from_user_id = 62194) AND (to_user_id <> 62194)
UNION
SELECT from_user_id AS receiver,related_goods_id,TEXT,`read_status`,create_time FROM dialogue
WHERE
(from_user_id <> 62194) AND (to_user_id = 62194)
ORDER BY create_time DESC) AS newTable
INNER JOIN
wuye_db.`register_user` u ON receiver = u.ID
GROUP BY receiver
ORDER BY create_time DESC