根据用户分组查出用户的发言次数和对应的绑定账号信息

select  
count(chat.chat_content) as times,
chat.created_at,user_relation.transaction_account,user_im_info.imcounselor 
from chat left  
join user_relation on user_relation.user_id = chat.user_id 
left join user_im_info on chat.user_id = user_im_info.user_id   
where chat.created_at > 1554739200  and  chat.created_at < 1554825599  
group by chat.user_id;