SELECT *, SUM(amount) as totalRecharge FROM `wallet_transaction` WHERE `usetype`='PURCHASED' AND datetime >= '2020-12-28 22:32:18' AND user_id IN (SELECT `portfolioholder_userid` FROM `portfolioholder_detail` WHERE `portfolioholder_subcategoryname`=''Home Salon') GROUP BY user_idfloat(99.67) Freelance PHP expert in Chandigarh, India : vedtomer@gmail.com