SELECT DISTINCT
a1.id,
a1.assetcode,
a1.`name`,
a1.`status`
a2.`name` AS className,
a3.`name` AS typeName,
a4.site_name
FROM a1
LEFT JOIN a2 ON a2.`id`=a1.classId
LEFT JOIN a3 ON a3.id=a1.typeId
LEFT JOIN a4 ON a4.uid=a1.siteId
left join,distinct
SELECT DISTINCT
a1.id,
a1.assetcode,
a1.`name`,
a1.`status`
a2.`name` AS className,
a3.`name` AS typeName,
a4.site_name
FROM a1
LEFT JOIN a2 ON a2.`id`=a1.classId
LEFT JOIN a3 ON a3.id=a1.typeId
LEFT JOIN a4 ON a4.uid=a1.siteId
left join,distinct