How to get value from subquery in mysql?
But as i said you don't need in article
title and image, as they are already existent in books and you can always join the books table
But you would do this so
INSERT INTO article(title,price,cart_id,book_id,image_id) 
VALUES ('Book1',20.00,387,
(select b.id from books b  where b.title =  'Book1' limit 1),
(select b.image_id from books b where b.title =  'Book1' limit 1))