mysql-查询日期属于月份第几周

SELECT
  CONCAT(
   YEAR(DATE_ADD(send_date,INTERVAL - WEEKDAY(send_date) DAY) ) ,
   LPAD(MONTH(DATE_ADD(send_date,INTERVAL - WEEKDAY(send_date) DAY) ) ,2,'0') ,
   'W',
   (DAY(DATE_ADD(send_date,INTERVAL - WEEKDAY(send_date) DAY) ) - 1) DIV 7 + 1,
   '(',
   DATE_FORMAT(DATE_ADD(send_date,INTERVAL - WEEKDAY(send_date) DAY) ,'%m%d') ,
   '~',
   DATE_FORMAT(DATE_ADD(send_date,INTERVAL - WEEKDAY(send_date) DAY) + INTERVAL 6 DAY,'%m%d') ,
   ')'
   )