MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE user_company (
id int,
user_id int ,
company_id int );


insert into user_company values 
(1,61,1),
(2,71,1),
(3,81,1),
(4,91,2),
(5,10,2),
(6,11,2);
select * from user_company;


id
user_id
company_id


1
61
1

2
71
1

3
81
1

4
91
2

5
10
2

6
11
2


select company_id as company, 
       user_id  as user_id ,
       row_num  as row_num 
from 
    ( select *,row_number() over(partition by company_id order by id asc) as row_num
      from user_company
     ) as tbl 

order by company_id asc,row_num asc 


company
user_id
row_num


1
61
1

1
71
2

1
81
3

2
91
1

2
10
2

2
11
3


select concat('Company: ',company_id,' , User: ',user_id, ', position: ',row_num ) as my_row 
from 
    ( select *,row_number() over(partition by company_id order by id asc) as row_num
      from user_company
     ) as tbl 

order by company_id asc,row_num asc 


my_row


Company: 1 , User: 61, position: 1

Company: 1 , User: 71, position: 2

Company: 1 , User: 81, position: 3

Company: 2 , User: 91, position: 1

Company: 2 , User: 10, position: 2

Company: 2 , User: 11, position: 3