select 
年,
sum(if(月 = 1,值,0)) as m1,
sum(if(月 = 2,值,0)) as m2,
sum(if(月 = 3,值,0)) as m3,
sum(if(月 = 4,值,0)) as m4
from cook
group by 年
order by 年