MariaDB 10.2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE invoice_paid (
  `id` INTEGER,
  `uuid` VARCHAR(3),
  `paid_date` DATETIME,
  `paid_amount` INTEGER
);
INSERT INTO invoice_paid
  (`id`, `uuid`, `paid_date`, `paid_amount`)
VALUES
  ('1', 'ABC', '2019/5/1', '15'),
  ('2', 'ABC', '2019/5/5', '80');
CREATE TABLE invoice (
  `id` INTEGER,
  `uuid` VARCHAR(3),
  `user_id` INTEGER,
  `created_date` DATETIME,
  `amount` INTEGER,
  `name` VARCHAR(2)
);
INSERT INTO invoice
  (`id`, `uuid`, `user_id`, `created_date`, `amount`, `name`)
VALUES
  ('1', 'ABC', '1', '2019/5/1', '100', 'xa'),
  ('2', 'PQR', '2', '2019/5/5', '150', 'xb');
SELECT i.id, i.uuid, i.user_id, i.created_date, i.amount - COALESCE(p.amount, 0) AS amount, i.name
FROM invoice i
LEFT JOIN (SELECT uuid, SUM(paid_amount) AS amount
           FROM invoice_paid
           GROUP BY uuid) p ON p.uuid = i.uuid
ORDER BY i.id


id
uuid
user_id
created_date
amount
name


1
ABC
1
2019-05-01 00:00:00
5
xa

2
PQR
2
2019-05-05 00:00:00
150
xb