Fetch multiple rows data from another table based on matching ID's

I have two spaerate tables that can't be linked together directly.

Table 1 has User with multiple ID's and Table 2 has unique users. I need to create new calculated column in table 2 for matching user with all conversation ID from table 1, added in a single row