<?php 

$sql = "SELECT COALESCE(MAX(num_proveedor), 0) + 1 AS next_num
        FROM proveedores
        WHERE id_empresa = ?";

$stmt = $pdo->prepare($sql);
$stmt->execute([$empresaId]);

$numProveedor = (int)$stmt->fetchColumn(); 

------------------------------------

$sql = "SELECT * FROM personal WHERE Cedula2 = :cedula";
$stmt = $pdo->prepare($sql);
$stmt->execute([':cedula' => $cedula]);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // Aquí haces lo que necesites con los datos
    // echo $row['Nombre'];  por ejemplo
    echo '';
}
-------------------------------------------------------------
$sql = "SELECT * FROM personal WHERE Cedula2 = :cedula";
$stmt = $pdo->prepare($sql);
$stmt->execute([':cedula' => $cedula]);

$personal = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($personal as $row) {
    // Aquí haces lo que necesites con cada registro
    // Ejemplo: echo $row['nombre'];
    echo '';
}
-------------------------------------------------------------
$sql = "SELECT * FROM personal WHERE Cedula2 = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([$cedula]);

$personal = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($personal as $row) {
    echo '';
}
-------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------
-------------------------------------------------------------