交叉去重分组排序

(select * from table where
    (sid={$sid} and sender_deleted <> 1) or (mid={$mid} and receiver_deleted <> 1)
order by create_at desc limit 999999) a 
group by concat(least(sid,mid),'-',greatest(sid,mid))
limit 0,10