使用MYSQL从Prestashop中的订单ID获取产品清单

Im new in Prestashop ,i want to get the details of products from the id order from the data base so can anyone help me with the mysql query .

Use PrestaShop classes instead of mysql query:

    $order = new Order($id_order);
    $details = $order->getProductsDetail();
    d($details);