หาค่า Max ของแต่ละ Record ( ย้ำ Record ไม่ใช่ Field) ด้วย MySQL หายังไงครับ

SELECT QR_COMP.*
FROM
(
   (SELECT id ,'P1' AS `label`, P1 as `value` FROM a1)
   UNION
   (SELECT id ,'P2' AS `label`, P2 as `value` FROM a1)
   UNION
   (SELECT id ,'P3' AS `label`, P3 as `value` FROM a1)
) AS QR_COMP ,
(
   SELECT id ,MAX(`value`) AS MAX_VALUE
   FROM
   (
      (SELECT id ,'P1' AS `label`, P1 as `value` FROM a1)
      UNION
      (SELECT id ,'P2' AS `label`, P2 as `value` FROM a1)
      UNION
      (SELECT id ,'P3' AS `label`, P3 as `value` FROM a1)
   ) AS QR_INNER
   GROUP BY id
) AS QR_MAX
WHERE (QR_COMP.`VALUE` = QR_MAX.MAX_VALUE) AND (QR_COMP.ID = QR_MAX.ID)
ORDER BY id;

<?php
   // สมมติว่าเชื่อมต่อฐานข้อมูลแล้ว
  // สมมติ ว่าตัวแปร $link คือตัวเชื่อมต่อ
   $sql = "SELECT MAX(Column_Name) MAXIMUM FROM table_name";
   $result = mysqli_query($link, $sql);
   $array = mysqli_fetch_array($result);
   echo $array;
?>