I need to get all the columns of a table and a custom column in the same query, I tried this way:
SELECT (SELECT * FROM clans WHERE ID=1), (SELECT COUNT(*) FROM contas WHERE Clan=1) AS Membros;
It is giving error by trying to get more than one column per SELECT.
Resolved.
SELECT *, (SELECT COUNT(*) FROM contas WHERE Clan=1) AS Membros FROM clans WHERE ID=1;
You can use JOIN to make your query simpler:
SELECT
c.*,
COUNT(cn.Clan) AS membros
FROM clans c
INNER JOIN contas cn
ON cn.Clan = c.ID
WHERE c.ID = 1
GROUP BY c.ID