select * from A ,(select * from B) C where A.id=B.aid
select case when A is null then '0' else A end as B
SELECT user_id
FROM user_remain
GROUP BY user_id
HAVING count( user_id ) >1
select case when A is null then '0' else A end as B
SELECT user_id
FROM user_remain
GROUP BY user_id
HAVING count( user_id ) >1