처음부터 PDO 가져오기 결과를 여러 번 반복하는 방법은 무엇입니까?

<code class="php"><?php
$pdo = new PDO('mysql:host=' . $host . ';dbname='.$database, $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $pdo->prepare('SELECT * FROM mytable WHERE active = 1 ORDER BY name ASC');
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute();

// Store the results in an array
$rows = $stmt->fetchAll();

// First iteration
foreach ($rows as $r) {
    // Perform desired actions starting from the first row
}

// Second iteration
foreach ($rows as $r) {
    // Perform additional actions starting from the first row again
}
?></code>