This is the query statement - `SELECT m.*, GROUP_CONCAT(food SEPARATOR ','), GROUP CONCAT(alcohol SEPARATOR ','), GROUP_CONCAT(drugs SEPARATOR ',')
FROM main m
INNER JOIN food f ON f.username = m.username AND f.date = m.date
INNER JOIN alcohol a ON a.username = m.username AND a.date = m.date
INNER JOIN drugs d ON d.username = m.username AND d.date = m.date`