Untitled

use Drupal\Core\Database\Database;

$entity_id = 123; // Replace with your desired entity ID.

// Get the database connection.
$database = Database::getConnection();

$query = $database->select('workflow_transition_history', 'wth')
  ->fields('wth', ['uid'])
  ->condition('wth.entity_id', $entity_id)
  ->orderBy('wth.timestamp', 'DESC')
  ->range(0, 1);

$query->leftJoin('user__field_first_name', 'ufn', 'wth.uid = ufn.entity_id');
$query->leftJoin('user__field_last_name', 'uln', 'wth.uid = uln.entity_id');

$query->fields('ufn', ['field_first_name_value'])
  ->fields('uln', ['field_last_name_value']);

$result = $query->execute();

foreach ($result as $row) {
  $first_name = $row->field_first_name_value;
  $last_name = $row->field_last_name_value;
  
  // Do something with the first and last names.
  // For example, you can print them or use them as needed.
}