MySQL选择将同一表中的多行分组


MySQL select grouping multiple rows from same table

我试图创建一个查询,从同一个表中选择多行,将它们像数组一样分组。现在我使用php来选择它们,如下所示:

$tks = mysqli_query($con,"SELECT * FROM hof ORDER BY tks DESC LIMIT 5");
$top_ths = mysqli_query($con,"SELECT * FROM hof ORDER BY ths DESC LIMIT 1");
$top_tha = mysqli_query($con,"SELECT * FROM hof ORDER BY tha DESC LIMIT 1");
----

我想把它们合并到一个查询中,这样我就得到了一个关联数组。类似这样的东西:

(SELECT * FROM hol ORDER BY tks DESC LIMIT 5) AS tks
UNION
(SELECT * FROM hol ORDER BY ths DESC LIMIT 1) AS top_ths

所以tks包含所有5行,top_ths包含1行。有可能吗?谢谢

从组行的下方开始,使附加字段

(SELECT *, 1 as `group` FROM hol ORDER BY tks DESC LIMIT 5)
UNION
(SELECT *, 2 as `group` FROM hol ORDER BY ths DESC LIMIT 1)