I have 5 table:
`users`
`user_profiles`
`courses`
`user_subjects`
`subjects`

that use to pull related subject for each user using this query: 

```
SELECT
    --snip--
    u.id,
    u.username,
    u.level,
    c.name course_expertise,
    GROUP_CONCAT(s.name ) subjects
FROM
    user_profiles up
INNER JOIN users u ON up.user_id = u.id
INNER JOIN courses c ON up.course_expertise_id = c.id
INNER JOIN user_subjects us ON u.id = us.user_id
INNER JOIN subjects s ON us.subject_id = s.id
GROUP BY u.id

```

Resulting in: 

```
+----+-----------+-----------+-----------------------------------+-------------------+
| id | username  | level     | course_expertise                  | subjects          |
+----+-----------+-----------+-----------------------------------+-------------------+
|  2 | lecturer  | lecturer  | Information Technology Management | sub1, sub2, sub3  |
|  3 | professor | professor | Information Technology Management | sub4, sub 5, sub6 |
+----+-----------+-----------+-----------------------------------+-------------------+

```

Is there a way i can achive something like this:

```
+----+-----------+-----------+-----------------------------------+----------+----------+----------+
| id | username  | level     | course_expertise                  | subject1 | subject2 | subject3 |
+----+-----------+-----------+-----------------------------------+----------+----------+----------+
|  2 | lecturer  | lecturer  | Information Technology Management |   sub1   |   sub2   | sub3     |
|  3 | professor | professor | Information Technology Management |   sub4   |   sub5   | sub6     |
+----+-----------+-----------+-----------------------------------+--------------------------------+

```

**Edited**
`subjects` column, will always contain 3 subject