select users.id, users.email,
       COUNT(distinct orders.oid) as orders,
       COUNT(distinct travellers.tid) as travellers
from users
    left join orders on users.id = orders.userid
    left join travellers on users.id = travellers.userid
where users.email = @email
group by users.id, users.email