MYSQL按月查询数据，可直接用于highcharts的数组

  $query = mysql_query("SELECT xm1,((sum(xm22)-sum(xm5+xm6+xm7+xm8+xm9+xm10+xm11+xm12+xm13))/sum(xm22))*(sum(xm22)-sum(xm5+xm6+xm7+xm8+xm9+xm10+xm11+xm12+xm13)-0)/(sum(xm22)-sum(xm5+xm6+xm7+xm8+xm9+xm10+xm11+xm12+xm13))*(xm4*sum(xm14)/(sum(xm22)-sum(xm5+xm6+xm7+xm8+xm9+xm10+xm11+xm12+xm13)))*( sum(xm15)/sum(xm14)) oee
   FROM `sbxl` where xm2='测试台' and xm3='产品名称' group by date_format(xm1, '%Y-%m');");
  while($rows = mysql_fetch_row($query)){
    $riqi[] = substr($rows[0], 0, -3);
    $oee[] = round($rows[1]*100,2);
  }
  foreach($riqi as &$v) $v = "'$v'";
  $agexsee=implode(',', $oee);
  $namexsee=implode(',', $riqi);

当数据库的基础数据 xm1字段格式为2019-01-01时即可用

重点：按月分组代码：group by date_format(xm1, ‘%Y-%m’);");