--另一个思路 select count(distinct case when order_id is null then uf.uid end) as cnt from order_log lg right join user_info uf on lg.uid=uf.uid

--另一个思路 select count(distinct case when order_id is null then uf.uid end) as cnt from order_log lg right join user_info uf on lg.uid=uf.uid