my $query ="select tp.user_type, nm.user_num 
from users us
inner join nums nm on nm.user_num=us.user_num
inner join type tp on us.user_type=tp.user_type
where nm.user_id =:user_id
and nm.num=:num";