SQL查询优化：统计用户关联的电话号码数量

SELECT `user`.username, COUNT(IF(LENGTH(passenger.phone) = 18, 1, NULL)) AS count FROM `user` LEFT JOIN passenger ON passenger.username = `user`.username GROUP BY `user`.username