如何将具有相同字段的两个表的结果连接到一个字段Codeigniter？

Question

I use Codeigniter

My invalid SQL query:

SELECT *, (SELECT menu FROM sepetim WHERE SiparisId = S.Id) AS menum
FROM siparisler AS S
WHERE onay = 1 AND BayiId = '1'
ORDER BY Id desc

I have tables like this:

 Table1           Table2
   Id             Id | Text
    1             1    name1
    2             1    name2
                  2    name3

Current result:

Wanted result:

Can you help me? Thanx.