select name, email, contactno, sum(amt) as total_amt
from customer_info
inner join recharge_info on rid = customerid
group by name, email, contactno
or
select
ci.name,
ci.email,
ci.contactno,
(select sum(ri.amt) from recharge_info ri where ri.rid = ci.customerid) as total_amt
from customer_info ci