How to get distinct results joining 3 MySql tables in Codeigniter?

I know this is late but may help someone

PHP Code:

$db      = \Config\Database::connect();
$builder = $db->table('payments p');
$builder->select('*');
$builder->join('flats f', 'f.flat_id = p.flat_id', 'left');
$builder->join('users u', 'u.user_id = f.owner_id', 'left');
$builder->groupBy('name');
$query = $builder->get();
$data['table_joined'] = $query->getResult();