laravel db table unique code example

Example: eloquent get distinct

$ad->getcodes()->distinct('pid')->count('pid');