select date(visit_time)                                                                     as date,
       concat(round(count(distinct ot.user_id) / count(distinct vt.user_id) * 100, 1), '%') as cr
from order_tb ot,
     visit_tb vt
where date(visit_time) in (date(order_time))
group by date;