一对多SQL

UPDATE coin_account ac
INNER JOIN (
    SELECT
        SUM(caf.amount) as amount,
        caf.account_id as account_id
    FROM
        coin_account_flow caf where caf.type = 13
    AND caf.direction = 1
    GROUP BY
        caf.account_id
) b ON b.account_id = ac.id
SET ac.total_num = ac.total_num - b.amount,
 ac.avaliable_num = ac.avaliable_num - b.amount,
 ac.update_time = NOW()
WHERE
    ac.total_num - b.amount >= 0