SELECT t1.columnName, t2.columnName
FROM databaseName.user.table AS t1
INNER JOIN databaseName.user.table AS t2 ON t1.id = t2.id