加个字段:pids id pids 1 0 2 1 3 1,2 4 1,2,3 如果提成比率一样,语句要简单点: update tablename set `帐户金额`=`帐户金额`+{$ticheng} where id in(select pids from tablename where id='{$id}');提成比率不一样update tablename set `帐户金额`=`帐户金额`+(CASE `用户推广等级` WHEN 'A' THEN '{$ticheng_A}' WHEN 'B' THEN '{$ticheng_B}' WHEN 'C' THEN '{$ticheng_C}') where id in(select pids from tablename where id='{$id}');
子节点,父节点....保留引用,这样就可以无限的引用了
id pids
1 0
2 1
3 1,2
4 1,2,3 如果提成比率一样,语句要简单点:
update tablename set `帐户金额`=`帐户金额`+{$ticheng} where id in(select pids from tablename where id='{$id}');提成比率不一样update tablename set `帐户金额`=`帐户金额`+(CASE `用户推广等级` WHEN 'A' THEN '{$ticheng_A}' WHEN 'B' THEN '{$ticheng_B}' WHEN 'C' THEN '{$ticheng_C}') where id in(select pids from tablename where id='{$id}');