Prestashop 1.7如何将数据库中的数据显示到tpl

$db = new PDO('mysql:host=localhost;dbname=your_database_name;charset=utf8', 'your_username', 'your_password');

$query = "SELECT * FROM ps_product";
$result = $db->query($query);

$smarty = new Smarty();
$smarty->assign('products', $result->fetchAll(PDO::FETCH_ASSOC));

<table>
  <tr>
    <th>产品名称</th>
    <th>价格</th>
  </tr>
  {foreach $products as $product}
    <tr>
      <td>{$product.name}</td>
      <td>{$product.price}</td>
    </tr>
  {/foreach}
</table>