SELECT fd.id, fa.name as faname, fa.username FROM fa_distance fd LEFT JOIN fa on fa.id = fd.fa_id WHERE fa.related_mdm = AND DATE(fd.createdAt) = CURDATE() AND status = 'Active' ORDER BY fd.createdAt DESC