Add an ordinal column to a MySQL query

Select *, (@number: = @number + 1) as number  from        (SelectU.mobile,u. ' Name ',ROUND((Select  sum(R.realamount) fromT_recharge RwhereR.userid=U.id andR.status='1'),2) Rechargesum,ROUND((Select  sum(W.realamount) fromT_withdrawal WwhereW.userid=U.id andW.status='1'),2) Withdrawalsum,ROUND(sum(F.ownamount),2) Ownamountsum,ROUND(sum(F.platformfunds),2) Platformfundssum,ROUND((Select sum(Fd.amount) fromT_fund_detail FDwhereFd.userid=U.id andFd.type='3'),2) Feesum,ROUND(sum(F.result),2) Cashresult, u.balance,u2. ' Name ' asfroms fromt_user u Left JoinT_financing F onF.userid=u.id Left JOINT_user U2 onU2.id=U.fromidGroup  byU.id)Temp,(select @number: =0) b

Used is (@number: = @number + 1) as number and (select @number: =0) b, above is an example of multiple tables

An example of a table is as follows:

Add an ordinal column to a MySQL query