select name,
age
from pserson
where id in
(select person_id
from foo
where v = 10086);
select name,
age
from pserson
where id in
(select person_id
from foo
where v = 10086);