select date(visit_time) date
,concat(ROUND(count(distinct order_tb.user_id)/count(distinct visit_tb.user_id)*100,1),'%')  cr 
from order_tb
right join visit_tb
on order_tb.user_id = visit_tb.user_id and date(visit_time) = date(order_time)
group by 1
order by date