SELECT id,relationship FROM god.xn_member where id in(

select uid from (
        SELECT uid,count(*) as total FROM god.xn_account where money=3000.00 and addtime>='2023-11-09 00:00:00' and addtime<='2023-11-09 23:59:59'  group by uid HAVING total > 1
) as temp

) ;