project stats

with stat as (
select s.user_id, sum(s.issues) as issues, sum(s.overdues) as overdues, s.workflow_status_id from members m
left join project_user_stats s on m.project_id = s.project_id
where m.project_id = 1
and m.in_team=True
group by s.user_id, s.workflow_status_id
)
select row_to_json(t), t.user_id from (
select user_id, array_agg(issues) as issues, array_agg(overdues) as overdues, array_agg(workflow_status_id)
as workflow_status_id
from stat
group by user_id) t