By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create Table ps_category_product (id int, id_product int, id2 int)
CREATE TABLe ps_product (id_product int)
INSERT INTO ps_product VALUES (1),(2),(4)
INSERT IGNORE INTO ps_category_product SELECT 1184, id_product , 0 FROM ps_product;
SELECT * FROM ps_category_product
id | id_product | id2 |
---|---|---|
1184 | 1 | 0 |
1184 | 2 | 0 |
1184 | 4 | 0 |