科室添加成功！
';
} else {
echo '
添加失败：' . mysqli_error($connID) . '
';
}
}
}
$sql = "SELECT d.*, COUNT(doc.id) as doctor_count FROM departments d
LEFT JOIN doctors doc ON d.id = doc.department_id
GROUP BY d.id ORDER BY d.name";
$result = mysqli_query($connID, $sql);
?>