looks like the workaroud solution is:
first step, execute below query:
select accountid from account where location = 'us'
Once we get all accountid then, execute below query:
select * from opp where ownerid = 'xxxx' or parentaccountid in ( all accountid)
Then, we can get what we want.