[assassingod]

You will need to use a while loop:

PHP Code:

$user = $DB_site->query("
    SELECT * FROM user WHERE userid < 5
");
    while($user = $DB_site->fetch_array())
    {
        $username = $user['username']; 
        eval('$somevar .= "' . fetch_template('YOUR_TEMPLATE') . '";');
    }