php sql get column names and alias code example

Example: alias mysql

SELECT coluna
AS alias_coluna
FROM tabela AS alias_tabela;