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