UPDATE $table1 a,$table2 b
SET a.balance = a.balance + b.income,b.status= 1
WHERE a.user_id = b.user_id AND b.id = 5 AND b.status = 0;
或
UPDATE $table1 a INNER JOIN $table2 b
ON a.user_id = b.user_id
SET a.balance = a.balance + b.income,b.status= 1
WHERE b.id = 5 AND b.status = 0;
UPDATE $table1 a,$table2 b
SET a.balance = a.balance + b.income,b.status= 1
WHERE a.user_id = b.user_id AND b.id = 5 AND b.status = 0;
或
UPDATE $table1 a INNER JOIN $table2 b
ON a.user_id = b.user_id
SET a.balance = a.balance + b.income,b.status= 1
WHERE b.id = 5 AND b.status = 0;