```
select *, (uremain - IFNULL(sremain, 0)) as remain from (
select
coin_record.*,
users.remain as uremain,
(select sum(count) from coin_record cr1 where
cr1.id >
coin_record.id) sremain
from coin_record left join users on
users.id = coin_record.user_id
) as coin_record
```