mysql 树形汇总_SQL中的树状数据整理（Mysql）

I have two tables in my database

Table A with columns user_id, free_data, used_data

Table B with columns donor_id, receptor_id, share_data

Basically, a user (lets call x) has some data in his account which is represented by his entry in table A. The data is stored in free_data column. He can donate data to any other user (lets call y), which will show up as an entry in Table B. The same amount of data gets deducted from the user x free_data column.

While entry in Table B gets created, an entry in Table A for user y is also created with free_data value equal to share_data. Now user y can give away data to user z & the process continues.

Each user keep using their data & the entry used_data in Table A keeps on adding up to indicate how much data