var mysql = require('mysql');
var connection = mysql.createConnection(
    {
      host     : 'hackteams.c6p7kpyzcymg.us-east-1.rds.amazonaws.com',
      user     : 'test',
      password : 'password',
      database : 'hackteams'
    }
);

// user's username:
var user = 'tiger';

connection.query("SELECT * FROM team WHERE user1_id = (SELECT id FROM users WHERE username = '" + user + "') UNION SELECT * FROM team WHERE user2_id = (SELECT id FROM users WHERE username = '" + user + "') UNION SELECT * FROM team WHERE user3_id = (SELECT id FROM users WHERE username = '" + user + "') UNION SELECT * FROM team WHERE user4_id = (SELECT id FROM users WHERE username = '" + user + "')", function(err, rows, field) {
	for (i in rows) {
		console.log(rows[i]);
		// do something...
	}

	connection.end();
});