select uv.room_id,room_name,count(distinct uv.user_id) user_count from
user_view_tb uv join room_info_tb rt on uv.room_id=rt.room_id
where left(in_time,2)=23 or (left(in_time,2)<23 and left(out_time,2)=23)
group by uv.room_id,room_name
order by user_count desc

人要去重