求助，我想让图例按照一定顺序排列，并且周数（例如‘2024-11’）同时也要排序

怎么实现呢，我现在的周数是乱的。

select * from

(SELECT  distinct  si_cReason 体系, concat(YEAR(bi_cTime) ,'-',bi_cWeek) 日期 ,bi_nQuantity 数量, YEAR(bi_cTime) 年 ,WEEK(bi_cTime) 周,si_cDepartment 部门,si_cFillno

FROM t_system_info system

left join t_basic_info basic on basic.bi_cFillno = system.si_cFillno

right join (SELECT num,类别 from (SELECT 1 as num,'体系不合理' as 类别 union all SELECT 2,'体系未执行' union all select 3,'无体系' union all SELECT 4,'待确认') numbers)a on a.类别 = system.si_cReason

where  1=1

${if(len(starttime)=0,""," and  DATE_FORMAT(bi_cTime,'%Y-%m')>='"+starttime+"'")}

${if(len(endtime)=0,""," and DATE_FORMAT(bi_cTime,'%Y-%m') <='"+endtime+"'")}

${if(fine_username="Alice","and basic.bi_cType in ('原材料','半成品','成品') ",if(fine_username="Mike","and basic.bi_cType in ('客户','成品') ",""))}

ORDER BY concat(YEAR(bi_cTime) ,'-',WEEK(bi_cTime)))b

right join (SELECT num,类别 from (SELECT 1 as num,'体系不合理' as 类别 union all SELECT 2,'体系未执行' union all select 3,'无体系' union all SELECT 4,'待确认') numbers)a on a.类别 = b.体系