PHP/SQL查询:合并两个只有唯一记录的表并计数星期六

SELECT 
`a`.`name` AS `Name`,
COUNT(`e`.`ID`) AS `Saturdays`
FROM `accounts` AS `a`
LEFT JOIN `events` AS `e` ON `e`.`account_id` = `a`.`ID` AND WEEKDAY(`e`.`date`) = 5
GROUP BY `a`.`ID`