SELECT ptime,SUM(paying)AS paying ,SUM(payed)AS payed FROM
(SELECT YEAR(paytime)AS ptime,CASE WHEN confirm=0 THEN amount ELSE 0 END AS paying ,
CASE WHEN confirm=1 THEN amount ELSE 0 END AS payed
FROM agriculture WHERE `level`=1 ) aa
GROUP BY ptime
(SELECT YEAR(paytime)AS ptime,CASE WHEN confirm=0 THEN amount ELSE 0 END AS paying ,
CASE WHEN confirm=1 THEN amount ELSE 0 END AS payed
FROM agriculture WHERE `level`=1 ) aa
GROUP BY ptime