SET @SQL = NULL;

SELECT
    GROUP_CONCAT(DISTINCT
        CONCAT(
            'SUM(IF(o.id = ', '''', ppo.outletid, '''', ', ppo.stok, 0)) as ',
            o.nama
        )
    ) INTO @SQL
FROM produk_produk_outlet ppo
LEFT JOIN outlet o ON (o.id = ppo.outletid);

SET @SQL = CONCAT(
    'SELECT pp.nama, ',
    @SQL,
    ' FROM produk_produk_outlet ppo ',
    'LEFT JOIN produk_produk pp ON pp.id = ppo.produkid ',
    'LEFT JOIN outlet o ON (o.id = ppo.outletid) ',
    'GROUP BY pp.id'
);

PREPARE stmt FROM @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;