MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mpt_companies
             (company_id integer,
              company_title varchar(256));
CREATE TABLE mpt_payment_methods
             (payment_method_id integer,
              payment_method_title varchar(256));
CREATE TABLE mpt_payments
             (payment_id integer,
              company_id integer,
              payment_method_id integer,
              payment_amount decimal(8,2));
INSERT INTO mpt_companies
            (company_id,
             company_title)
            VALUES (1,
                    'Company A'),
                   (2,
                    'Company B');

Records: 2  Duplicates: 0  Warnings: 0


INSERT INTO mpt_payment_methods
            (payment_method_id,
             payment_method_title)
            VALUES (1,
                    'Cash'),
                   (2,
                    'PayPal'),
                   (3,
                    'Wire');

Records: 3  Duplicates: 0  Warnings: 0


INSERT INTO mpt_payments
             (payment_id,
              company_id,
              payment_method_id,
              payment_amount)
             VALUES (1,
                     1,
                     1,
                     10.00),
                    (2,
                     2,
                     3,
                     15.00),
                    (3,
                     1,
                     1,
                     20.00),
                    (4,
                     1,
                     2,
                     10.00);

Records: 4  Duplicates: 0  Warnings: 0


SELECT x.company_id,
       x.company_title,
       group_concat(payment_amount_and_method) payment_data
       FROM (SELECT c.company_id,
                    c.company_title,
                    concat(pm.payment_method_title, ':', sum(p.payment_amount)) payment_amount_and_method
                    FROM mpt_companies c
                         INNER JOIN mpt_payments p
                                    ON p.company_id = c.company_id
                         INNER JOIN mpt_payment_methods pm
                                    ON pm.payment_method_id = p.payment_method_id
                    GROUP BY c.company_id,
                             c.company_title,
                             pm.payment_method_id,
                             pm.payment_method_title) x
      GROUP BY x.company_id,
               x.company_title;


company_id
company_title
payment_data


1
Company A
Cash:30.00,PayPal:10.00

2
Company B
Wire:15.00