You can get required output with some sub-query like below
select
SC.MyIndex AS Index1,
(SELECT count(sc1.status) as z FROM statuscount SC1 WHERE sc1.status = 0 group by sc1.myindex,sc1.status ) AS ZERO,
(SELECT count(sc1.status) as o FROM statuscount SC1 WHERE sc1.status = 1 group by sc1.myindex,sc1.status ) AS One,
(SELECT count(sc1.status) as t FROM statuscount SC1 WHERE sc1.status = 2 group by sc1.myindex,sc1.status ) AS TWO,
(SELECT count(sc1.status) as th FROM statuscount SC1 WHERE sc1.status = 3 group by sc1.myindex,sc1.status ) AS Three,
(SELECT count(sc1.status) as fo FROM statuscount SC1 WHERE sc1.status = 4 group by sc1.myindex,sc1.status ) AS Four,
(SELECT count(sc1.status) as fi FROM statuscount SC1 WHERE sc1.status = 5 group by sc1.myindex,sc1.status ) AS Five
FROM statuscount SC group by sc.myindex
Another solution in different form is
select
sc.MyIndex,sc.status,count(sc.status) AS TotalCount from statuscount SC group by sc.myindex,sc.status
Hope it helps.