select 
date(visit_time) as date,
concat(round(count(distinct o.user_id)*100 / count(distinct v.user_id),1),'%') as cr
from visit_tb v
left join order_tb o
on date(visit_time)=date(order_time)
group by date