SELECT COUNT(id) FROM `agendas` WHERE funcionario_id = agendas.funcionario_id GROUP BY date_format(inicio, '%Y-%m-%d'), funcionario_id limit 1

SELECT
    distinct
    (SELECT COUNT(id) FROM `agendas` WHERE funcionario_id = agendas.funcionario_id GROUP BY date_format(inicio, '%Y-%m-%d'), funcionario_id limit 1) as dia,
    (SELECT COUNT(id) FROM `agendas` WHERE  funcionario_id = agendas.funcionario_id and inicio BETWEEN DATE_ADD(now(), INTERVAL(1 - DAYOFWEEK(now())) DAY)  AND DATE_ADD(now(), INTERVAL(3 + DAYOFWEEK(now())) DAY) GROUP BY date_format(inicio, '%u') limit 1) as semana,
    (SELECT COUNT(id) FROM `agendas` WHERE funcionario_id = agendas.funcionario_id GROUP BY date_format(inicio, '%Y-%m'), funcionario_id limit 1) as mes,
    (SELECT COUNT(id) FROM `agendas` WHERE funcionario_id = agendas.funcionario_id GROUP BY date_format(inicio, '%Y'), funcionario_id limit 1) as ano,
    (select users.name from users,funcionarios where funcionarios.id = agendas.funcionario_id and users.id = funcionarios.user_id) as nome
from
    agendas