php开两个表,php-按条件加入两个表

在这里我想加入两个表,并想产生像

Akbar Travels building 2018-10

Thrikandiyur Quarters 2018-10

Akbar Travels building 2018-11

Thrikandiyur Quarters 2018-11

这里我有两个表,名称表A,表B,表A的结构看起来像这样

category_id category_name

5 Akbar Travels building

6 Thrikandiyur Quarters

表B的结构看起来像这样

id paying_month parent_category

1 2018-10 5

2 2018-10 5

3 2018-11 5

4 2018-11 5

5 2018-10 6

为了获得输出,我在这里编写了我的代码

public function get_date_wise_pdf_report($from, $to)

{

$query=$this->db->query("SELECT * from tableA A left join tableB B on A.category_id = B.parent_category and B.paying_month BETWEEN '{$from}' AND '{$to}' ");

return $query->result();

}

但是当我用这个的时候

Akbar Travels building 2018-10

Akbar Travels building 2018-10

Akbar Travels building 2018-11

Akbar Travels building 2018-11

Thrikandiyur Quarters 2018-10

我无法在此处按组给出陈述,如果我只给出两行,将会出来,请帮助我解决