Mysql 查询用户2 的聊天记录列表

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