Вывод группы автора новости в короткой и полной новости / Show author's user group in news

Unknown column 'group_name' in 'field list'
Error Number:
1054
Code:
SELECT `group_name` FROM dle_users WHERE name='Alireza'

SELECT * FROM " . PREFIX . "_users LEFT JOIN " . PREFIX . "_usergroups ON (" . PREFIX . "_users.user_group=" . PREFIX . "_usergroups.id) WHERE  id = '".$row['autor']."'"

$sql_group = $db->super_query( "SELECT * FROM " . PREFIX . "_users LEFT JOIN " . PREFIX . "_usergroups ON (" . PREFIX . "_users.user_group=" . PREFIX . "_usergroups.id) WHERE  id = '".$row['autor']."'" );
$tpl->set( '{id_group}', $sql_group['group_name'] );