中文排序

SELECT `a`.*, `b`.`bonus_name`, `b`.`cost_per` 
FROM `crm_member_card_bonus` `a` 
LEFT JOIN `crm_mcard_bonus` `b` ON a.bonus_id = b.id 
WHERE a.card_list_id = 7944 AND (a.expire_time > 1482136073 OR a.expire_time = 0) AND a.status = 1 
ORDER BY CONVERT(b.bonus_name USING gbk) ASC ,a.expire_time DESC ;