SELECT c.ID, a.companyID, CONCAT(c.companyName, " [ ", c.companyNo, " ] ") as companyName
FROM (`user_module_access` a)
LEFT JOIN `company` c ON `c`.`ID` = `a`.`companyID`
LEFT JOIN `tbl_usermaster` b ON `b`.`fldid` = `a`.`userID`
WHERE `b`.`userid` =  'akmal'
AND `c`.`is_delete` =  0
GROUP BY `a`.`companyID`
ORDER BY `c`.`createdTS` desc