Try the following query for result. For date range you can generate a string for respective date.
select *
from
(
select attendance, `date`
from AttendanceRecord
) src
pivot
(
COUNT(`date`)
declare date cursor for `2020-01-01`, `2020-02-01`, `2020-03-01`, `2020-04-01`)
) piv