SELECT
    cast(sum(if(order_id is null,1,0)) as signed) cnt
FROM user_info u left join order_log o on u.uid=o.uid