select
*from
wx_chat
where
create_time in
(
SELECT MAX(create_time)
from
wx_chat
where
receiver_id =2 or sender_id=2
GROUP BY
CONCAT(if(sender_id>receiver_id,sender_id,receiver_id),if(sender_id<receiver_id,sender_id,receiver_id))
)
ORDER BY create_time desc