我正在尝试将产品从购物车（从购物车产品）复制到订单产品表
通过将列名准备为order\u id的值，这个查询可以这样工作吗

// Create the order

    $order_id = $this->order->store();

    // Copy products from cart and assign them to the order

    $req = "INSERT INTO order_product (order_id, product_id)
    SELECT :order_id, product_id, 
    FROM cart_product, cart
    WHERE cart.user_id = :id";

    $bind = array(
        "id" => $_SESSION['id'],
        "order_id" => $order_id
    );

    return  $this->Sql($req);

我使用的是一个微观框架，sql函数就是在这个框架中产生的。
我希望查询变成这样

INSERT INTO order_product (order_id, product_id)
SELECT 3, product_id, 
FROM cart_product, cart
WHERE cart.user_id = 2