我想有一个类别，是从另一个表的总链接视图排序列表。
我只是试着在谷歌上搜索一下，然后想出了这个例子。

SELECT 
    'categories'.'catId',
    'categories'.'title',
    'categories'.'description',
    (
        SELECT SUM(hits)
        FROM 'links'
        WHERE 'catId' = 'categories'.'catId'
    ) AS 'hits_count'
FROM 'categories'
LEFT JOIN 'links'
ON 'links'.'catId' = 'categories'.'catId'
WHERE 'status'='1'
ORDER BY 'hits_count'

这样行吗？还是有别的办法？
最新的尝试

<?php
include 'config.php';
$db = new DB();
$sql="SELECT categories.name,
    (
        SELECT SUM(hits)
        FROM links
        WHERE catId = categories.catId
    ) AS hits_count
FROM categories
LEFT JOIN links
ON links.catId = categories.catId
WHERE links.status=1
ORDER BY hits_count DESC";

$query = $db->db->prepare($sql);
$categories = $query->execute();
?>
<?php print_r($categories) ?>

只带着数字1回来了