How to make PHP Crosstab?

SELECT DATE_FORMAT(tracked_date,'%Y-%m-%d') as my_tracked_date,
sum(ss.term_id IN (3) OR tt.parent IN (3)) AS category3,
sum(ss.term_id IN (4) OR tt.parent IN (4)) AS category4,
sum(ss.term_id IN (5) OR tt.parent IN (5)) AS category5,
sum(ss.term_id IN (6) OR tt.parent IN (6)) AS category6
FROM wp_terms AS t LEFT JOIN a AS ss ON t.term_id = ss.term_id LEFT JOIN b AS tt
ON ss.term_id = tt.term_id
WHERE DATE_FORMAT(tracked_date,'%Y-%m-%d') IS NOT NULL
GROUP BY my_tracked_date ORDER BY my_tracked_date