SELECT
c.id_cxc AS ID,
cl.nombre AS Cliente,
CONCAT('$', FORMAT(c.monto, 2)) AS Monto,
CONCAT('$', FORMAT(c.abonado, 2)) AS Abonado,
CONCAT('$', FORMAT(c.monto-c.abonado, 2)) AS Resta
FROM ec_cuentas_por_cobrar c
JOIN ec_clientes cl ON c.id_cliente = cl.id_cliente