MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLe PC(maker varchar(10), model varchar(10))
INSERT INTO PC VALUES('Me','pc1')
CREATE TABLE Product(model varchar(10), price decimal(10,2))
INSERT INTO Product VALUES('pc1',10.2)
CREATE VIEW PCView
AS SELECT maker, a.model, price
FROM PC a JOIN Product b
ON a.model=b.model;
CREATE PROCEDURE createPCList (
    INOUT PCList varchar(4000)
)
 BEGIN
     DECLARE finished INTEGER DEFAULT 0;
     DECLARE _maker VARCHAR(100) DEFAULT "";
     DECLARE _price INTEGER DEFAULT 0;
-- declare cursor for PCView
     DECLARE curPC CURSOR FOR SELECT maker, price FROM PCView;

-- declare NOT FOUND handler
    DECLARE CONTINUE HANDLER 
        FOR NOT FOUND SET finished = 1;
SET PCList = '';
    OPEN curPC;

    getPC: LOOP
        FETCH curPC INTO _maker,_price;

        IF finished = 1 THEN 
            LEAVE getPC;
        END IF;
        -- build list
        SET PCList = CONCAT(_maker,"- PC ", "for ", _price, PCList);

    END LOOP getPC;
    CLOSE curPC;

END
call createPCList(@pclist)
SELECT @pclist


@pclist


Me- PC for 10


SELECT * FROM PCView


maker
model
price


Me
pc1
10.20