MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table other_table(
    product int(9) ,
    sold_quantity int); 

insert into other_table values 
(1,10),
(2,10),
(3,10),
(4,10),
(5,10),
(1,10), 
(2,10), 
(3,10), 
(4,10), 
(5,10);

create table my_table(
   cart_id int,
    product int(9) ,
    sold_quantity int) ; 

Records: 10  Duplicates: 0  Warnings: 0


CREATE PROCEDURE insert_into_table(cart_id int )
BEGIN       
   insert into my_table (cart_id, 
                      product, 
					  sold_quantity
					  ) 
   select  cart_id, 
           product,
           sold_quantity
   from other_table limit 10 ;
END;
call insert_into_table(5);
select * from my_table;


cart_id
product
sold_quantity


5
1
10

5
2
10

5
3
10

5
4
10

5
5
10

5
1
10

5
2
10

5
3
10

5
4
10

5
5
10