LogCompany with nick

SELECT `lc`.*,`k`.`Nick`
FROM `LogCompany` `lc`
LEFT JOIN `Konta` `k` ON `lc`.`user_id`=`k`.`id`
WHERE `lc`.`company_id`='%d' AND `lc`.`flag`='%d'
ORDER BY `lc`.`id` DESC
LIMIT 0,100;