how can i count multiple occurence of multiple fields in a column corresponding to another attribute?

how can i count multiple occurence of multiple fields in a column
corresponding to another attribute?

I am new to MySQL.
I am having a table having fields as (NAME FRUIT TIME)
NAME FRUIT TIME
AJAY MANGO 10:10 SACHIN APPLE 12:00 RAJ MANGO 10:00 AJAY MANGO 12:00 AJAY
MANGO 11:00 AJAY APPLE 12:00 RAJ BANANA 12:00 AJAY BANANA 12:00 SACHIN
BANANA 2:00 SACHIN MANGO 12:00 RAJ MANGO 12:00 SACHIN APPLE 12:00 AJAY
APPLE 12:00 AJAY APPLE 12:00
NOW I want TO GET OUTPUT FROM THE ABOVE TABLE AS
NAME MANGOCOUNT APPLECOUNT BANANACOUNT AJAY 3 3 1 RAJ 2 0 1 SACHIN 1 2 1
I TRIED FOR UNION AS
'SELECT NAME, COUNT(*) AS MANGOCOUNT FROM FRUIT_EAT WHERE FRUIT='MANGO'
GROUP BY NAME UNION ALL SELECT NAME, COUNT(*) AS APPLECOUNT FROM FRUIT_EAT
WHERE FRUIT='APPLE' GROUP BY NAME UNION ALL SELECT NAME, COUNT(*) FROM
FRUIT_EAT WHERE FRUIT='BANANA' GROUP BY NAME;'
i am getting result as
NAME MANGOCOUNT AJAY 3 RAJ 2 SACHIN 1 AJAY 3 RAJ 0 SACHIN 2 AJAY 1 RAJ 1
SACHIN 1
I am not understanding my mistake if you please help me out??