$query  = "SELECT `b`.`team`, `u`.`id`, `u`.`attack`
            FROM `battle_users` AS `b`
            JOIN `users` AS `u` ON `b`.`id_user` = `u`.`id`
            WHERE `b`.`id_battle` = $id_battle
                AND `b`.`hod` = 0
                AND `b`.`die` = 0
                AND `b`.`timeout` = 0
                AND `u`.`rank` != 0";
$result = $pdo -> query($query);

while ($row = $result -> fetch())
{
    //etc
}