在mysql中通过别名获取行后无法生成json数据

I am fetching rows from two tables through JOIN and by using alias.but it's not creating json data after assigning rows to json array.I am fetching rows from two tables through JOIN